Converting seconds to days, hours, mins and secs

M

mike.sloper

I receive a spreadsheet which contains the lengths of calls people hav
made in seconds. These actually run into days. Is there a formula I ca
enter to converts miliions of seconds in to days, hours, minutes an
seconds
 
P

Peter Atherotn

Mike

There are 86400 seconds in a day. so use this as a divisor
and custom format the answer as d:hh:mm:ss

Regards
Peter
 
J

JMay

Range A1:D4's Values are:
A B C
D
1 345662 =A1/86400 =INT(B1) Days
2 =(B1-C1)*24 =INT(B2) Hours
3 =(B2-C2)*60 =INT(B3) Minutes
4 =(B3-C3)*60 =INT(B4) Seconds

Will Display:

345,662 4.000718 4.00 Days
0.017222 -
Hours
1.033333 1.00
Minutes
2.000000 2.00
Seconds

Change A1 to test;
HTH
JMay
 
Top