Thread
:
Converting to minutes and seconds
View Single Post
#
4
Posted to microsoft.public.excel.misc
JaB
Posts: n/a
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
Reply With Quote