Calculating Time Duration with In/Out

jl.furstenberg

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.

Julie Fortney

@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.

Paul Newcome

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:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

jl.furstenberg

Thank you!!