Re: How to record hours worked

471 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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