Basic excel functions

[dharmender mehra]

What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in
hrs:minutes:seconds) format?

 

[Guest]

Assuming the number of seconds is in A1,

=A1/86400


Then, format the cell as custom "hh:mm:ss"

 

[Guest]

To Excel, dates are just integers (the count of days since 12/31/1899) and
times are decimal fractions of days (noon is 0.5)

So.....Divide 29,852 by the number of seconds in a day to arrive at the
decimal fraction.
=29852/(60*60*24)

Then use one of the Time formats on the value.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

=A1/86400

Custom Format hh:mm:ss

 

[JE McGimpsey]

Time is stored as fractional days, so divide by 24*60*60:

A1: 29852
A2: =A1/86400

format as hh:mm:ss