converting a general number into minutes and seconds
Posted by Elizabeth B on August 23, 2001 7:37 AM
I work in a call center and track the length of time certain call types take, then forecast staffing levels based on those numbers. i download a program to excel that has the time in seconds. I'd like to have it read as minutes.seconds. Took the number and divided it by 60. Of course, it does this: 336 seconds converts to 5.60 minutes-- should read 6.0 minutes. checked about everywhere i can think of to get it right. any ideas?
Posted by IML on August 23, 2001 7:49 AM
Assuming your seconds are in A1, use
=TIME(,INT(A1/60),MOD(A1,60))
with the formual cell formatted as
[m]:ss
good luck
Posted by elizabeth b on August 23, 2001 8:06 AM
IML--Thanks for sharing that!! It worked. On to other things. TTYS
Posted by Mark W. on August 23, 2001 8:31 AM
Or, simply...
=A1/86400
Posted by IML on August 23, 2001 8:54 AM
60*60*24! very nice Mark.
