How to find the difference (HHmm) between two separate times (HHmm).

[deckthehalls]

Hello all, 

I am trying to figure out a formula that can easily figure out the difference between two times (HHmm) in Alteryx. Military time is what I need to use. (1530-930 = 6 hours) Visual example below: 

Start Time	End Time	Difference
930	1530	6

[Luke_C]

Hi @deckthehalls 

This formula should do the trick. It parses each time into an alteryx read-able format and then applies the datetimediff function. The below link is super helpful in breaking down each datetime function.

DateTime Functions | Alteryx Help

Datetimediff(
Datetimeparse(padleft(tostring([End Time]),4,'0'),'%H%M'),
Datetimeparse(padleft(tostring([Start Time]),4,'0'),'%H%M'),'hours')

[binuacs]

@deckthehalls Another way of doing this with the DateTime Tool

[deckthehalls]

This worked perfectly for what I needed. Thanks!

[Luke_C]

@deckthehalls Happy to help! Don't forget to mark the solutions so others can find them easier. 

[fharper]

@deckthehalls please do mark the answer you like as a solution as it helps others find answers faster and respects the assistance provided by the contributor