Date Difference - x Days x Hours

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!!

FY21Q3-IR_Time_to_Complete.xlsx

IRsTimetoComplete.yxmd

Date Time

Accepted answers

jrgo

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.

All comments

jrgo

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.

IRsTimetoComplete.yxmd

Thank you. Worked like a charm.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335