Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to record hours worked

154 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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