Formula for Hours worked without dates over midnight

Topic Labels: Dates & Timezones
1120 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I need help please.

imagine a very large roster and to change finish and start dates and finish and start times over midnight is unmanageable. Need the formula for example 23:00 start time and 07:00 finish time to get 8:00 hrs in third column without the date.

if i cant do this will need to find another programme or stick to current one.

2 Replies 2

Dear @Ben_Bilbilov,

Welcome to Airtable Community !

Please elaborate a bit more on this. What is the setup like ? A simple formula would be

DATETIME_DIFF({Finish Date},{Start Date},'h')

You can check the formula references on this help article


4 - Data Explorer
4 - Data Explorer

Hi Mo.

I have thousands of hours to allocate and hence the entry of date and time for each start and finish over midnight is to time consuming.

one field has date and then the times are written as 18:00 to 03:00 and half the times over midnight with variations.

With excel i use =mod(finish time - start time, 1)

as this doesn’t work in airtable what is the equivalent formula