Datetime_diff need formula to return value as Days, Hours, Minutes

Hello Friends,

Needing to use datetime_diff to return days, hours, and minutes. I can only get the days to return the value. Tried all different types of formula nothing is working. Any thoughts?



Try:
DATETIME_DIFF({date end},{date start},'days')&' days '&MOD(DATETIME_DIFF({date end},{date start},'hours'),24)&' hours '&MOD(DATETIME_DIFF({date end},{date start},'minutes'),60)&' minutes'

1 Like

Hi Kamille, I can’t thank you enough! You’re brilliant! A thousand thank you’s! I hope one day I can be as smart as you are. :slightly_smiling_face::slightly_smiling_face::slightly_smiling_face::wink:

It’s all practice. I just use Airtable a lot haha

I want to do something similar but only looking at the how many days lost.

@Elaine_Winter then all you need is the first part of the formula.

1 Like

Thanks! I had been struggling a lot with that.