Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Payroll Formula Help (Time Duration)

Topic Labels: Formulas
585 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Aloha! Looking for help. Need help with a formula. I tried this:

Here’s an example:

On 6/21/19: Clock in at 6:47 AM
One 6/21/19: Clock out at 11:00 AM
On 6/21/19: Clock in at 11:30 AM
On 6/21/19: Clock out at 1:00 PM
On 6/21/19: Clock in at 1:15 PM

DATETIME_DIFF({Time Out (1)},{Time In (1)},{Time Out (2)},{Time In (2)},{Time Out (3)},{Time In (3)}, ‘minutes’)

This is what I keep getting back in return:
Time duration: -63142200000

Help Please! I am at a loss!!!

1 Reply 1

DATETIME_DIFF() can only handle the difference between two times at once. You’d need to do:
DATETIME_DIFF({Time Out 1},{Time In 1},'minutes')+DATETIME_DIFF({Time Out 2},{Time In 2},'minutes')+DATETIME_DIFF({Time Out 3},{Time In 3},'minutes')