I have cells that pull case start time, case end time, case duration in minutes, case duration in minutes plus the TAT. So if, my example, the case started at 1315 and ended at 1445, S-B=90 + 30 is still 120 minutes.īut, the slot time minutes for 7am to 3pm is 105 minutes and the slot time for 3pm to 7pm is 15 minutes.Ĭonversely, if the case began at 6:30am and ended at 8 am we still have 2 hours of time used, but only 90 minutes count for the time slot of 7am to 3pm Multiply your rate of pay by decimal hours to get your total pay before taxes. To ensure an integer result, consider INT (DAYS ()). DAYS really does return enddate - startdate thus if either date has a time component (for example 'T15:15'), the number of days returned may not be integer. So 41 hours, 15 minutes equals 41.25 hours. Note that DAYS does not count the first day of the period, but NETWORKDAYS does. In this example your partial hour is 15 minutes: 15/60 0.25 Add your whole hours back in to get 41.25 hours.
Take your number of minutes and divide by 60. In the example, +30=120.įor a case that starts and ends in a given time slot, the time slot duration would be 120 minutes, easy.īut, if the case ends with less than 30 minutes left in a given time slot, I need to subtract only the time used in that slot and move the remainder to the next slot. You only need to convert 15 minutes into decimal hours.
Add in the 30 minutes the staff needs to clean or prepare the room, the Total Case Duration would be 120 minutes. So, for example, a patient comes into the room at 0700 and leaves at 0830, "D" would equal 90 minutes. So, Total Case Duration = D+30, which we can call "E" Patient occupation of the room time is: - = "D" We have a default turn around time (TAT) of 30 minutes for each case done. The next time grouping could be 3 PM to 7 PM and there is 240 minutes available for the room. So, if I have time period of say, 7 AM to 3 PM, that is a total of 480 minutes of total time for that room. I thought I could save a great deal of time by asking here first.Īn operating room has a certain number of rooms it can use during given shift. Your (Davide’s) English is obviously more than sufficient. Even better for easing international cooperation: Use English (UK) UI (user interface). Attempting to create a spread sheet that can calculate the number of minutes an operating room is used on a given shift. A tip: you could enable Use English function names under Options - LibreOffice Calc - Formula to have the functions spelled right for you.