Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need formula that will read time as min:sec in excel
Nikki,
If I understand correctly: the Custom format [mm]:ss will accomplish the first, and [ss] the second. hth, Doug "Nikki2865" wrote in message ... Im trying to create a format within excel that will let excel read the time as min:sec instead of hours:sec or hours:min. Then I want to create a formula to automatically convert that cell into a separte cell showing all min:secs as seconds only. Any ideas? I dont think it is possible due to the default within Excel in regards to the ":" sign. Need any and all help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read specific time in NOW() function | Excel Worksheet Functions | |||
Excel formula to read contents | Excel Discussion (Misc queries) | |||
msg box with finished time, please read | Excel Worksheet Functions | |||
Open file to write and read at the same time | Excel Programming | |||
Read cell formated as Time | Excel Programming |