MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Elapsed Time Calculation


Posted by Cheryl P on June 20, 2001 3:40 PM

I am trying to format a worksheet for a surgical department where the total amount of time spent on each surgical procedure per day will be added for a total amount of hours and minutes for a month. For example: procedures may take anywhere from 15 minutes to 6 hours 15 minutes, totaling perhaps 15 procedures per day - then totaling these hours/minutes for the overall monthly total.... Perhaps totaling 250 hours 27 minutes per month. Am user-friendly, but not an expert. Any in-depth explanation will be greatly appreciated.


Posted by Mark W. on June 20, 2001 3:53 PM

Cheryl, suppose you want to sum the following times:

6:15, 5:24, 3:33, 4:40, 6:23

Simply, use Excel's SUM() function and format the
results as [h]:mm to get 25:15.

Posted by Cheryl P on June 20, 2001 4:04 PM

Tried a few simple calcs.....worked great....you are a god.

Posted by Mark W. on June 20, 2001 4:17 PM

Glad it worked! Well, gotta go... I hear they're
serving ambrosia tonight. : )