Need Help on Formula

[Pinky]

Hi,

My data is in below format. I wanted to subtract two dates like this 3/22/2017 14:20 -3/22/2017 14:21 for each number. Date format is in below.can any one help on this? Please let me know if you have any questions.

Number	UpdatedDate
AAA	3/22/2017 14:20
AAA
AAA	3/22/2017 14:21
BBB	9/29/2017 16:02
BBB
BBB
BBB	9/29/2017 16:29
CCC	2/22/2018 15:48
CCC
CCC	2/22/2018 16:19

[BenMoss]

I think this is the problem. If you look at the original sample data it does not have seconds. Some appear to have.

Ben

[Pinky]

Hi BenMoss,

Your formula is working but date difference is not calculating few dates. Date difference is zero is showing for below dates.I have pasted few of the date samples where as date difference is zero. Can you help on this?

Forex:

Max_DateTime_out	Min_DateTime_Out
02/09/2018 8:03:41	02/08/2018 15:32:42
02/05/2018 14:13:29	03/01/2018 12:03:50
02/06/2018 10:20:01	02/08/2018 11:18:46

[BenMoss]

Pinky can you please ensure you post the data as it is at the start of the workflow (i.e. a single column), as I believe this is confusing things.

I tried the following based on the first line you posted here, with the structure...

Number	UploadDate
AAA	02/08/2018 15:32:42
AAA
AAA	02/09/2018 8:03:41

and again, it seems to work fine. The only problem is it is trimming the seconds as this was not specified in your original sample data, but this still doesn't lead the result to being zero.

Ben

see attached.

[Pinky]

It is working now. You are right the format is different for few dates.

Thank you everyone. All the above formulas helped me.