Displaying seconds in hh:mm:ss format

P

PCLIVE

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
 
J

JE McGimpsey

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
 
V

vezerid

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
 
G

Guest

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
 
P

PCLIVE

Thank you all.
It works great!

Paul

JE McGimpsey said:
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

PCLIVE said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top