Forum Discussion
Recording a stopwatch time
I keep track of my workouts and put a stopwatch time in my excel spreadsheet. It is always changed to clock time. I want to keep the same format as I enter it. Example: I list my stopwatch run tim...
Set the Number Format of the cell(s) in which you want to register your times to the custom number format
[m]:ss.0
Thank you for your response. I entered the format you suggested and typed 27:59.1
When I clicked back on the same cell, Microsoft shows it as 12:27:59 AM
Excel will certainly show that in the formula bar, but does it display it that way in the cell too?
- It is the formula bar, but I copy the cell for a different day, and I want to change one digit by a few seconds, and I need to change 2 numbers and delete the AM or PM.
It would be nice if Microsoft had a stopwatch time only. I guess that is too difficult for them.
Thanks for your help.
