Posted to microsoft.public.excel.newusers

Posts: n/a

how to find time difference between timestamps to a millisecond?

I have two columns which contain timestamps in the format of yyyy-mm-dd
hh:mm:ss:msmsms (the last three digits are the milliseconds). I need to find
the difference of the timestamps in ss:msmsms format.

I am trying to implement a VB function to do this as there is no predefined
function available. Can anyone please assist?

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time difference	Stephanie	Excel Worksheet Functions	5	March 21st 06 10:06 PM
Calculating Time difference based on a condition	sonnethg	Excel Discussion (Misc queries)	4	October 11th 05 09:25 PM
calculate negative or positve difference in time	kpmoore	Excel Discussion (Misc queries)	2	January 5th 05 01:35 AM
Calculating time difference	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 23rd 04 02:29 AM
What is the formula for getting time difference e.g. ("4 hrs 15 m.	Sandeep Manjrekar	Charts and Charting in Excel	3	December 4th 04 05:18 AM

All times are GMT +1. The time now is 01:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us