Time difference

[Feras95p]

Dear all,

I want to calculate the time difference  between two columns for example 

like what's the time difference between the start and K complete the output in one column and the time difference between the K complete and E complete in one column.

Any help in that?

[MarqueeCrew]

@Feras95p ,

using a datetime tool or a formula, you'll want to convert these strings into real datetime formats. 

then you can use a datetimediff() formula and convert the answer to minutes or hours. 

cheers,

 mark

[Qiu]

@Feras95p 
This can be done relatively easy by DateTimeDiff. Dont what unit you want for the unit, difference in Seconds is given in the sample flow.

[Feras95p]

Hi @Qiu ,

Thanks for helping, I want in Hours:minutes

[MarqueeCrew]

Hint:

mod(121,60) = 1

tostring((121-mod(121,60))/60)+":"+
Padleft(tostring(mod(121,60)),2,"0")

that should get you 2:01

 cheers,

 mark

 from my iPhone

[Qiu]

@Feras95p 
Is this one looking better?

[Feras95p]

Hi @Qiu,

Thanks a lot ! 

One more question why in the output the last column K-E the first row 1:6 and it should be 1:06 because some of them will be 1:3 so I will not know if it's 1:30 or 1:03. Is there a way to solve this problem?

[Qiu · Accepted solution]

@Feras95p 
A PadLeft function would do the trick. Check below and mark it accepted if you like it.

[Qiu]

@Feras95p 
THank you for the mark. Appreciate.