Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to minutes and seconds
Hi there
Does anyone know how to convert a number into minutes and seconds in the following format - mm:ss Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to minutes and seconds
To expand - I would like to do this when the number is the result of a MAX
formula. I have tried using the custom mm:ss format but this just gives me the result 00:00 for some reason. "JaB" wrote: Hi there Does anyone know how to convert a number into minutes and seconds in the following format - mm:ss Many thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to minutes and seconds
In which units is the number expressed (seconds, minutes, hours, ... ) ?
-- AP "JaB" a écrit dans le message de news: ... To expand - I would like to do this when the number is the result of a MAX formula. I have tried using the custom mm:ss format but this just gives me the result 00:00 for some reason. "JaB" wrote: Hi there Does anyone know how to convert a number into minutes and seconds in the following format - mm:ss Many thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to minutes and seconds
At the moment, the figure expressed is in seconds but displayed just as a
general number. "Ardus Petus" wrote: In which units is the number expressed (seconds, minutes, hours, ... ) ? -- AP "JaB" a écrit dans le message de news: ... To expand - I would like to do this when the number is the result of a MAX formula. I have tried using the custom mm:ss format but this just gives me the result 00:00 for some reason. "JaB" wrote: Hi there Does anyone know how to convert a number into minutes and seconds in the following format - mm:ss Many thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to minutes and seconds
Thanks Je,
You saved me some typing. Cheers -- AP "JE McGimpsey" a écrit dans le message de news: ... XL stores times as fractional days, so if you want a true XL time, you'll need to divide by 24*60*60: A1: 23 A2: =A1/86400 === 0:00:23 In article , JaB wrote: At the moment, the figure expressed is in seconds but displayed just as a general number. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting to minutes and seconds
XL stores times as fractional days, so if you want a true XL time,
you'll need to divide by 24*60*60: A1: 23 A2: =A1/86400 === 0:00:23 In article , JaB wrote: At the moment, the figure expressed is in seconds but displayed just as a general number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting Minutes to Seconds | Excel Discussion (Misc queries) | |||
converting seconds into minutes | Excel Worksheet Functions | |||
How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
Converting minutes to seconds | Excel Discussion (Misc queries) | |||
converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions |