@Paul Newcome, Help!! TimeSheets 101 but I need a "break" (to account for them :))
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
-
I believe there should be something tucked away in here somewhere that has a solution for incorporating blanks.
Help Article Resources
Categories
Check out the Formula Handbook template!