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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]26-JAN-19 01.41.11.611000000 AM
[/TD]
[/TR]
[TR]
[TD]26-JAN-19 01.46.07.657000000 AM
[/TD]
[/TR]
</tbody>[/TABLE]

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