How Do I create a Timing Tool

  • Thread starter Thread starter timharding
  • Start date Start date
T

timharding

All,
I wonder if I can call on your expert advice.

I am looking to create a Timing Tool within Excel which will be able to
capture timings of specific user defined areas.

For Example looking to time specific sections of say for a telephone
call and the interaction the agent has with the Computer System..how
long specific actions take...and then from that be able to submit the
data into a sheet..and move on to another one.

This is so that summary data can be captured and analysed.

All help appreciated.

Regards

Tim Harding
 
Hi TIm,
For a telephone call, I presume seconds are precise enough.

Do you have the times captured in which case you can simply
subtract and you would have the difference and should format
as time, if it didn't you can format it yourself.

If you want to know how to capture a date & time take a look at Event
macros http://www.mvps.org/dmcritchie/excel/event.htm
You can use such events as selecting a worksheet,
double-click, select a cell, right-click,

The Timer in VBA only records seconds since midnight as a single
which is not adequate to check program timings for minimal data.
The NOW() function has an accuracy based on 18.2 ticks per second.
The Win API function winmm.dll is milliseconds since Windows was started.
http://www.mvps.org/dmcritchie/excel/slowresp.htm#timer
 
Back
Top