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

with the formual cell formatted as

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...


Posted by IML on August 23, 2001 8:54 AM

60*60*24! very nice Mark.