Counting hours only if they are before or after a certain time
I am part of a studio share with some friends, and we book through google calendar. We have an allotted amount of hours, and I'm making a spreadsheet that calculates how many hours we've used.
There are different types of hours; do not disturb, walk-in, visitors welcome, and late hours. Right now, my spreadsheet categorizes the hours based on the words in the title of the event (for instance, someone would name an event "jane, DND" and it would subtract a certain number of DND hours from jane).
However, late night hours are within a certain time frame. I'm thinking about the scenario where someones session begins during the day, and goes into the late night- I don't want late night time to eat into DND hours. I'm wondering if there is a way to calculate the duration before midnight, and the duration after midnight.
I'm able to input the start time and end time from google calendar, and calculate a total duration by subtracting start time from end time. But if I have a session from 8PM to 2AM, is there a way to calculate the time from 8PM to midnight, and then the time from midnight to 2AM?
Each row is a different session
[link] [comments]
Want to read more?
Check out the full article on the original site