Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to record hours worked

718 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sher_Plan_V
4 - Data Explorer
4 - Data Explorer

Hello!

Have seen a few recommended solutions but as a total novice ( I haven’t even used Excel formulas🙈) I can’t seem to follow them. My boss uses airtable, and has made one for me in her account.

It feels simple .

I need to keep track of the number of hours I work each day. Hours vary, but as an example:

Column 1 - clock in 9 am
Column 2 - clock out 5.15pm
Column 3 - number of hours worked

Please can someone help ?

Many thanks Vic

1 Reply 1

Hey, try to make a formula field with:

DATETIME_DIFF({Column 2}, {Column 1}, 'minutes')/60

Screenshot 2022-07-25 at 11.41.52 AM

You can find it set up here

And here’s a link to the list of formulas Airtable has