| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert minutes and seconds (in a date format) to numbers
I have a series of times (minutes, seconds) that I would like to convert to
equivalent numbers so they can be graphed. For example 3:11, 3 minutes, 11 seconds (stored as 3:11 am) to seconds (3 x 60 + 11 or 191) or 27:09:00, 27 minutes, 9 seconds (stored as 1/1/1900 3:09:00 AM) or 27 X 60 + 9 = 1629. Can this be done...easily? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to convert Minutes:Seconds format to minutes with seconds con | Excel Worksheet Functions | |||
| How do I convert hours, minutes, and seconds into decimal format? | Excel Worksheet Functions | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
Threaded Mode
