Time diff

[gagandeep_dhall]

Hi All,

I am trying to get difference of time in 2 columns to be displayed in minutes.

I was able to get it in seconds, but unable to get it in minutes.

Start Time	End Time	Difference (in mins)
19:51:23	20:52:21

Thanks,

Gagandeep

[messi007]

@gagandeep_dhall,

Please use the formula below

DateTimeDiff([End Time],[Start Time], "minutes")

Regards,

[atcodedog05]

Hi @gagandeep_dhall 

Hope this is what your formula looks like.

DateTimeDiff([End Time],[Start Time],"min")

Hope this helps 🙂

[gagandeep_dhall]

Hi,

Yes. Thanks it works.

But how to display the result in 2 decimals?

Regards,

Gagandeep

[atcodedog05]

like as in ?

its usually rounded off.

[AngelosPachis · Accepted solution]

Hi @gagandeep_dhall ,

You can use the formula that @messi007 and @atcodedog05  suggested above, but instead of using "minutes" as a unit, use seconds.

Then go on and divide that calculation with 60, so that will return you the decimals. 

(DateTimeDiff([End Time],[Start Time],"min") )/60

Make sure that the field in your formula is set to be a double or float to allow you to see the decimals, or to a fixed decimals 19.2 to keep only 2 decimals precision.

EDIT : So you should get something like this 

Regards,

Angelos

[gagandeep_dhall]

Thanks a lot for the help 🙂 

A small unrelated question. I have 3 files in a folder and I am using " * " in the Input as part of the files have dates in them.

For some of the tabs in the files, my flow works and it collates info from all the files, but for a few tabs it shoes information from just 1 file.

Please let me know if you would want me to ask it as a separate question.

Regards

[atcodedog05]

oh thats what you wanted @gagandeep_dhall 😅

[gagandeep_dhall]

haha. Yes 🙂 

But thanks for taking out time to read and reply to my query earlier.

I had another ask, which I shared in my earlier reply. Will you be able to help me out in that?

Regards

[atcodedog05]

Hi @gagandeep_dhall 

You take a look into this link it might help

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Assuming that you are reading the sheets and then passing it through dynamic tool to read data.

Is there any error or warning popping up?