
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2022 02:35 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 24, 2022 08:42 PM
Hey, try to make a formula field with:
DATETIME_DIFF({Column 2}, {Column 1}, 'minutes')/60
You can find it set up here
And here’s a link to the list of formulas Airtable has
