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?
Solved! Go to Solution.
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
@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.
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
@Feras95p
Is this one looking better?
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?
@Feras95p
A PadLeft function would do the trick. Check below and mark it accepted if you like it.
@Feras95p
THank you for the mark. Appreciate.