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.