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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I do remember working on a solution that incorporates breaks. Did you look through the thread to see if you could find what you needed?

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!