MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.