Displaying seconds in hh:mm:ss format
Thank you all.
It works great!
Paul
"JE McGimpsey" wrote in message
...
One way:
XL stores times as fractional days, so to get an XL time, divide seconds
by the number of seconds in a day:
=A1/86400
Format as [h]:mm:ss
In article ,
"PCLIVE" wrote:
I've got a cell with the total number of seconds in it.
A1 contains the number: 3,157
This number represents seconds. Is there a format or function that will
display this in hours-minutes-seconds (hh:mm:ss)?
Thanks,
Paul
|