| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format for elapsed time
I have data from my 4th grade class lab on the amount of time to melt an ice
cube, i.e., elapsed time, but the only way Excel 2007 seems to interpret time values (either in the Time or Custom categories for formatting data) are as time of day, even mm/ss shows as such. How can I show 4 minutes and 35 seconds as just that, not 4:35 AM?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format for Time Elapsed in Decimal | New Users to Excel | |||
| How can I convert or format an elapsed time to show mm:ss | Excel Discussion (Misc queries) | |||
| Format cells for elapsed time in mmm:ss? | Excel Discussion (Misc queries) | |||
| Format elapsed time in days? | Excel Worksheet Functions | |||
| How to format elapsed time for swimming scores | Charts and Charting in Excel | |||
Threaded Mode
