The Secret to Understanding Time in Excel

Do you find time math confusing in Excel? Ever struggle to get it to work just right?
If so, I’ll explain everything you need to know about time math in less than four minutes. Once you learn this, you won’t have any more trouble working with time in Excel.
SPREADSHEET LINK
spreadsheetlife.com/wp-conten...
COURSES
spreadsheetlife.com/all-courses/
OTHER
Templates: spreadsheetlife.com/templates/
Blog: spreadsheetlife.com/blog/
#exceltutorial

[@momfit2011]

Thanks. This was very helpful

[@spreadsheetlife]

So glad you found this helpful!! 😊👍

[@piercemybb]

what about the fact that a date shows up as a number like 45428. That's the number of days since Jan 1, 1900, right?

[@spreadsheetlife]

Yes, that's correct. The number 1 is equivalent to January 1, 1900. And since each day is equal to one, you add one to get January 2, 1900. Then this trend continues forward for all other dates.

[@piercemybb]

@@spreadsheetlife I'm sure that leap years complicate the entire thing....

[@spreadsheetlife]

Interestingly enough, leap years don't complicate it all that much. For example, you will find that if you add one to Feb 28, 2024, you get Feb 29, 2024. So the extra day in the leap years is included in the list of numbers that represent days.