Forum Discussion
How do I enter elapsed time in a cell?
I'm trying to compare various elapsed times in a spreadsheet. Excel keeps interpreting this as a date. For example, I have a time of 43 minutes and 0 seconds. If I set the cell number format to Time...
Hello Cliff
Everything is correct.
43:00 is shown in the cell.
1/1/1900 7:00:00 PM is shown in the formula bar. The date is shown when the time is 24 hours or greater.
1/1/1900 12:00 AM is the start of Excels date and time.
43 hours after this is 1/1/190 7:00 PM.
Changing the format to [mm]:ss changes the cell value to 2580:00.
43 hours x 60 minutes = 2580 minutes.