How do I subtract "break" time from my Time Tracking Columns?
I'm pretty far along on what I would have thought would be a normal function for a spreadsheet application called "Smart!" Anyway, I need to figure out the last steps in subtracting the break from the total hours worked. It shouldn't be hard as they are one of the following: 0:15; 030; 0:45 & 0:00 or 1:00, whichever that would be.
here's a link to the section that includes a sample of what I'm doing:
Here's a screenshot of what it looks like:
Here's my formula so far....
=((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) - (VALUE(LEFT([Start TIme]@row, FIND(":", [Start TIme]@row) - 1)) + VALUE(RIGHT([Start TIme]@row, 2)) / 60))
It seems I need the -VALUE([Break]@row, FIND(":", ...stuck in somewhere, but how to get the 15 minute increments as a chosen numeral for the total hours, I'm lost!
Please help if you have this!
Help Article Resources
Check out the Formula Handbook template!