@Paul Newcome, Help!! TimeSheets 101 but I need a "break" (to account for them :))

Options
KentB
KentB ✭✭
edited 03/04/23 in Formulas and Functions

I'm Working with TIme need to subtract breaks...

I've got a simple need. To allow my event managers to enter time in, breaks, and time out. I need a total to be sent on to accounting per event...Most formulas and sheets are already set up. For some reason, I can't figure out the break time issue!

Here's a link to what I have so far. (4) Time Formulas - Smartsheet.com

What it looks like:

FORMULA: which clearly leaves out the break...I've tried the middle I've tried the end...I'm sure I'm just missing something simple...like,= {-(VALUE(CENTER([Break]@row, ???))}

=((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))

Please help me @Paul Newcome, you're my only hope!

Thank you,

@KentB

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!