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?