Total Hours worked

Amber K.

I am using the following formula and it is not populating a response.

=IF([Time in]@row = ",", IF([Time Out]@row = ",", ([Time Out]@row - [Time in]@row ) * 24))

Darren Mullen

@Amber K. Unsure what your Time Out and Time In columns contain, but assume it's in some sort of time format.

To subtract the time values, you'll need to wrap both column references in teh TIME() function to create a time object like this:

=IF([Time in]@row = ",", IF([Time Out]@row = ",", (time([Time Out]@row) - time([Time in]@row) ) * 24))

Amber K.

No value is returned. Should show 7 hours.

Paul Newcome

That is because neither of your time cells equal a comma. If you are trying to get it to run if neither are blank, you would use <> "".

=IF([Time In]@row <> "",