Current Formula:
@Jennyb_Badass wrote:I have not been able to locate this formula
You need to combine different formula functions together to get the effect you want. Mixing and matching different formula functions together is a key aspect of the Airtable formula language. Try this.
IF(
AND({End Time}, {Start Time}),
DATETIME_DIFF({End Time}, {Start Time}, 'hours'),
0
)
Thank you. This formula is what I was looking for. Appreciate your help.
@Jennyb_Badass wrote:I have not been able to locate this formula
You need to combine different formula functions together to get the effect you want. Mixing and matching different formula functions together is a key aspect of the Airtable formula language. Try this.
IF(
AND({End Time}, {Start Time}),
DATETIME_DIFF({End Time}, {Start Time}, 'hours'),
0
)
Hi Kuovonne, This formula kind of works. It's rounding up the hours. If I have someone working 8:15am - 3:00pm, it returns 6 hours. Not 5.45. Is it possible to get the exact hours and minutes in the formula?
Can you help with calculating the minutes?
Start Time: 7/26/2023 6:15pm End Time: 7/26/2023 7:30pm
Formula returns 1 Hour
Formula Using:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.