Send to a Friend
How to track timings in MS Excel?
Asked by robmandu (21331)
January 12th, 2009
For example, if I open a plain jane worksheet and enter “1:10:25.003”—1 hour, 10 minutes, 25.003 seconds—Excel will auto-convert that to a time of day where it shows “10:25.0” in the cell, but “1:10:25 AM” in the formula field. Yuck!
I don’t see any numeric formats that look like they’ll do what I want.
I can lead off the cell with a single quote… but then that makes Excel treat the content as character instead of numeric. I’m hoping for something more elegant.
What do you suggest?
Using Fluther
or