Urgent Help!! excel formula to calculate time difference between two dates in Milli seconds with AM

[Himaja]

I have dates in excel as shown below:

26-JAN-19 01.41.11.611000000 AM

26-JAN-19 01.46.07.657000000 AM

<tbody>
</tbody>

I need to find the difference between 2 dates... In the example above, I have difference at Sec and milli seconds. How can I find the time difference. This is bit urgent

 

[Anthony47]

Did you realize that using "Urgent" alienates the interest of those who could help you?

To understand the format of the data (string? dates?) I suggest that you share a sample workbook.

Bye