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...
I was having the same trouble finding a solution. I wanted to enter one minute and 42 seconds of elapsed time. I formatted the cell to [mm]:ss and entered 1:42. The resulting display was 102:00. Not what I was looking for.
I found that by entering 0:1:42 I would get my desired result of 1:42.
I can't tell you how much time I wasted trying to find this answer...
I hope you found it already!