Date Difference - x Days x Hours

[#1]

I'm trying to calculate the number of days and hours between two date fields. It looks like many are calculating correctly, but there are some that are showing days and then negative hours. Can anyone help spot why I'm getting those negative numbers?

Source data and workflow attached.

Thanks!!

[jrgo · Accepted solution]

Use this formula on expression [Display Diff]

TOSTRING(FLOOR(TONUMBER([HoursDiff] / 24)))
+' days '
+ TOSTRING(TONUMBER(MOD([HoursDiff], 24)))
+ ' hours'

If that works for you, you can remove the [Days Diff] and [Hours Only] expressions.

[apathetichell]

you could be using datetimediff to calculate days. your formula for hours remaining should be

DateTimeDiff([Completed On], [Date / Time of Incident], "hours") - (DateTimeDiff([Completed On], [Date / Time of Incident], "days")*24)

I believe this is what you want.

[#4]

Thank you. Worked like a charm.