datediff display as hh:mm

[mrleetyler]

hi all

i am trying to do a DateDiff and display the result as a time factor.

e.g. 13:00 start 14:00 end i'd want the datediff to display at 01:00 not 60,1,3600 etc.

i'm working with this at the moment but it just doesn't work

the date diff displays correctly but i cannot get the format of the seconds converted to a time factor

is there a way to do this?

Text(DateDiff(DateTimeValue(input_ShiftStart.Text),DateTimeValue(input_ShiftEnd.Text),Seconds),"[$-en-US]hh:mm")

[StalinPonnusamy]

Hi @mrleetyler 

Text(DateDiff(TimeValue(input_ShiftStart.Text),TimeValue(input_ShiftEnd.Text),Hours), "[$-en-US]00") & ":00"

[mrleetyler]

hey Stalin,

that works fine for exact hours but in the event of for example a 90 minute datediff this method won't work

[StalinPonnusamy · Accepted solution]

Hi @mrleetyler 

Minutes Included.

Text(DateDiff(TimeValue(input_ShiftStart.Text),TimeValue(input_ShiftEnd.Text),Hours), "[$-en-US]00") &  ":" & Text(Mod(DateDiff(TimeValue(input_ShiftStart.Text),TimeValue(input_ShiftEnd.Text),Minutes), 60),"[$-en-US]00")