Time difference

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?

Samplee.xlsx

Workflow

Date Time

Udacity

Accepted answers

Qiu

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

1o019-Feras95p.yxmd

All comments

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.

1019-Feras95p.yxmd

Feras95p

Hi @Qiu ,

Thanks for helping, I want in Hours:minutes

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703