D
dharmender mehra
What formula can i use to convert 29852(in seconds) to 8:17:32 (which is in
hrs:minutes:seconds) format?
hrs:minutes:seconds) format?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Vergel Adriano
Assuming the number of seconds is in A1,
=A1/86400
Then, format the cell as custom "hh:mm:ss"
=A1/86400
Then, format the cell as custom "hh:mm:ss"
R
Ron Coderre
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
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
T
Teethless mama
=A1/86400
Custom Format hh:mm:ss
Custom Format hh:mm:ss
J
JE McGimpsey
Time is stored as fractional days, so divide by 24*60*60:
A1: 29852
A2: =A1/86400
format as hh:mm:ss
A1: 29852
A2: =A1/86400
format as hh:mm:ss