@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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!