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:

(3) Time Formulas -

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!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!