Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to record hours worked

886 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