I am using this formula which works great from from within the 24 hour time, but if I go from one day to the next it is off. =SUM((H1543-G1543)*24)
How can I enter a time of 9pm to 2am = 5 and still maintain the normal 6am to 3pm = 9?
Hi there - here's the issue I'm having:
I measure how long it takes our people to contact a lead that comes into our system. Currently, we track this Monday through Saturday, 9am to 9pm (Sundays are not counted). Here's the formula I'm working with...