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
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
Paul,
you need to divide by 86400. The format you seek can be found in
Format|Cells..., under the Number tab. Choose a Time format.
HTH
Kostis Vezerides
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 <[email protected]>,
"PCLIVE" <[email protected]> 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
Try
=A1/24/60/60
or
=A1/86400
formats as hh:mm:ss
--
Regards,
Peo Sjoblom
"PCLIVE" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
In B2 enter =A1/(24*60*60) and you should see 0.036539352
format as hh:mm:ss and you will see 00:52:37
___________________________________________
Gary's Student
"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
>
>
>
Thank you all.
It works great!
Paul
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
> "PCLIVE" <[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks