How do you format a cell so that the time you enter in reflected as hours and seconds?
I've tried by formatting the cell itself by picking hh:mm from the special category in the formatting section. However, whenever we enter in a time "08:24" for 8 min 24 secs, it always assumes it is 08:24 AM.
When I enter it in the long way (i.e. 00:08:24) and click on that cell, it says 12:08:24 AM. Any way to JUST show the minutes and seconds? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>