Calculating Time Duration with In/Out
Hello,
I have reviewed several posts on calculating time worked from in/out time entries. I tried to use one of the formulas previously presented (see screenshot), but I keep getting an Invalid Operation error. If it helps, I am trying to calculate time worked using the 12 hour format.
Answers
-
@Paul Newcome Paul, I've looked at several of your timekeeping solutions in the Community, so I think @jl.furstenberg's question might be right up your alley.
-
The problem is where you are subtracting
([Sun_out1]@row - [Sun_in1]@row)
Those are both text values and as such cannot be used in mathematical calculations. If that was possible, there would be no need for all of the workarounds.
There should be something in the below thread for you:
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!