How to record hours worked

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

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.