MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel millisecond adding

Posted by Dean R. Neill on October 01, 2001 12:21 PM

I'm trying to add minutes, seconds and milliseconds in a contest. I know how to seperate and add, but I'd like to use just one column instead of two or three. Any ideas?

Posted by Mark W. on October 01, 2001 12:49 PM

Format your cell as [mm]:ss.000

A millisecond is equivalent to 1/86400000 or

Posted by Mark W. on October 01, 2001 1:22 PM

By the way...

It appears that Excel's NOW() worksheet function
only has a precision of 1/100 of a second... So,
that won't be of much use to you!