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