Forum Discussion
Columns doesnt count right
So I got this example: The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24...
Try the below syntax:
=DATEDIF([Eff Dt],[Exp Dt]-(MOD([Eff Dt],1)>MOD([Exp Dt],1)),"d")&" days, "&TEXT(MOD([Exp Dt]-[Eff Dt],1),"hh "" hrs, "" mm "" mins""")
,where Eff Dt and Exp Dt are field names. Results are shown below (Diff field - calculated column) as an example.
Hope this helps!