Basic excel functions
 

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

Basic excel functions
 

Assuming the number of seconds is in A1,

=A1/86400


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



"dharmender mehra" wrote:

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

Basic excel functions
 

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


"dharmender mehra" wrote:

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

Basic excel functions
 

=A1/86400

Custom Format hh:mm:ss

"dharmender mehra" wrote:

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

Basic excel functions
 

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

A1: 29852
A2: =A1/86400

format as hh:mm:ss

In article ,
"dharmender wrote:

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