I have a column titled "event start time"(A1), a column titled " event end time" (B1) and a column titled " total event hours" (C1).
I have the third cell formulated to return the difference in hours, but I'm looking for help with a formula to calculate if the hours = 8 or more, to automatically deduct one hour for break.
If the time is less than 8 hours, to do nothing but just return the actual difference.
please help.
Bookmarks