PDA

View Full Version : stopwatch in Excel



Sathisc
03-10-2010, 05:43 AM
Hi,

I handle a team where they take calls, i have a AHT of 3 mins so i need to create a Stopwatch in excel that can give the exact timinings in minutes from the start of the call and any warning when the clock ticks 2 mins, so that my people can complete the call within time.

Thanks in Advance
Sathish

Artik
08-16-2010, 04:04 AM
You have waited for answer a bit, :) but I think you will be pleased.

Each tierce of time for counting has other color of cell (conditional formatting).
The class CTimer and module MSharedTimer wrote Karl E. Peterson (MVP)

Artik

valendj
08-16-2010, 07:30 AM
To Activate Click Cells in column A to Stop click any cell Past C1.