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

Himaja

Board Regular
Joined
Oct 14, 2013
Messages
59
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
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Anthony47

Well-known Member
Joined
Mar 29, 2006
Messages
1,707
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
 

Watch MrExcel Video

Forum statistics

Threads
1,098,847
Messages
5,465,065
Members
406,411
Latest member
Xiaoming

This Week's Hot Topics

Top