I need a way to calculate hours between two intervals. Example 3:00pm and 1:00am should yield 10. I'm using this to determine shift length for a day, then adding up multiple days to get hours scheduled in a week.
Currently I'm using "=b1-a1+(b1<a1)*24" where a1 is 3:00pm and b1 is 1:00am. This formula does yield the accurate result; however, when I attempt to add up multiple formulas like this to get a weekly total, my weekly total becomes astronomically high, and I have no idea why. I also always run into an issue where this becomes more difficult to calculate if the shift traverses midnight.
Please help.
Bookmarks