DateTimeDiff results without colon

[AKHAN]

I have the following date-time data and I am applying difference between columns 'time_out' & 'time_in' with formula as shown below but the result is not coming with colon in hours:minutes but instead its coming as decimal. I need the result in hours:minutes.  please suggest how can I come up with this result

[LordNeilLord · Accepted solution]

Hey @AKHAN 

There are a couple of different ways to do it listed here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Change-Minutes-to-Hours-Minutes/td-p/2...

[AKHAN]

Well received. Thank a lot. I tried the following in formula. 

PadLeft(ToString(Floor([Difference]/60), 0), 2, '0') +
":" + PadLeft(ToString(Mod([DIfference], 60), 0), 2, '0')

[grazitti_sapna · Accepted solution]

Hi @AKHAN , please refer to the screenshot for the solution and if this resolves your query please mark this post as a solution.

Thanks.

[AKHAN]

it was helpful as well. Thanks a lot. 

[grazitti_sapna]

@AKHAN  you are welcome.