A brief history of Excel Time!

**craigproudfoot** · 12-04-2009, 10:12 AM

Hi.
I have data entry in a spreadsheet which shows minutes, seconds and thousandths of a second - example looks as follows:
12:48:589 or 04:21:998

I would like to be able show the time difference between two data entries, so for example:
09:57:145 and 08:12:055 would give a difference of 1:45:090
12:07:985 and 18:59:788 would give a difference of 6:51:803
To be honest, I even struggled to work out the values on paper. Is this even possible? If so, can you let me know the number format I should be using as well as the formula or even better, post an excel sheet with the example.

Thank you in advance
Craig

**darkyam** · 12-04-2009, 10:20 AM

Does this work?

**DonkeyOte** · 12-04-2009, 10:32 AM

If as implied your times are stored as text with a colon before the thousandths (as opposed to a period delimiter) you can use

Please Login or Register  to view this content.

where B1 is end time and A1 start time.

**craigproudfoot** · 12-04-2009, 11:06 AM

Very impressive guys.

just used a period before the thousandths instead of a colon - looks better.
Thanks again

Craig

**F4085** · 02-18-2014, 10:40 AM

hello,

could you re-work this xls to calculate the difference between two times in format hh:mm:ss.sss??

thank you

**arlu1201** · 02-18-2014, 11:04 AM

F4085,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.