Using VBA, how to display decimal seconds using format and now functions?

Hello everyone!

I am using the following VBA macro, which inputs timestamps every time a key combination (alt+right arrow in this case) is pressed:

Please Login or Register  to view this content.

I would like this to display decimal seconds as well. Is there a quick change I can make to the formatting of "HH:MM:SS" which will work?

So far I've tried "HH:MM:SS.0" and similar variations, which only appends to the seconds whatever follows the period; and "HH:MM:SS:MS" and similar variations, but that only redisplays the minute and second values.

I am using Excel 2011 on Mac OS 10.9.1

Thanks!

EDIT: Added code tags

Please edit your post and include code tags around the code - this is one of the forum rules you agreed to when you joined. To add Code tags, edit the message, highlight the code and click the '#' button on the toolbar.

After doing that, you can try this as an alternative...

Please Login or Register  to view this content.

You should note that the VBA NOW() function seems to return whole seconds only. The easiest way to get the exact time is to use the WorkSheet Now() function, or the Windows API. The worksheet function is simpler...

You can remove the [] around Now() and compare the results to see the differences.

That reminds me...

Please Login or Register  to view this content.

is an alternative.

Originally Posted by G e r a r d

Please Login or Register  to view this content.

Gerard thank you for replying! This code doesn't work for me, it simply returns .00 after the seconds.

Cytop, thank you very much for your help, I feel like I'm almost there with your suggestion. My code right now looks like this:

Please Login or Register  to view this content.

This returns values which are formatted like so 17:13.49.84, which doesn't allow me to do any calculation on it.

Is there a way of getting the second decimal information and still use the numbers for calculations? What I need is to measure time intervals between two events in a series.

EDIT: EDIT: So for the solution of my problem I would just need to modify this:

Please Login or Register  to view this content.

, which gives the seconds and decimals to something that only gives decimals. Then I could make a time stamp in the following format: HH:MM:SS,ds which allows calculations.

Cytop, can you please help me? Thanks!