Hello Everyone,
I am new hear and I am looking solution for one problem I am facing right now.
I have data in excel which contain two type of data and time formatting which is dd/mm/yyyy 12/05/2022 3:12AM and second one is mm/dd/yyyy 05/13/2022 2:28AM. I am trying to unify one date format so that I can do some hours difference calculation. Because both date format is different it is providing me wrong number of hours difference.
I tried with text to column option but it is not helping.
If anyone know and want to share will be really appreciated.

Thanks
Amjad