Ola: Fab formula, its working fine. Now i have restrited my users to
enter only the system time. I have now 2 more challenges which have
cropped up for which i need you advise

1. The cell accepts system time in hour and minute format only but does
not record the seconds format. It would be fantastic if I could track
time in the following format : hh/mm/ss (system time)

2. Is there an option with which i can lock a cell the moment a user
enters the current system time? Eg: Start time : 10:00:01 (The moment
the user inputs this time fomat the cell should automatically get
locked and no one should be able to amend this cell apart from myself -
Automated Password lock)

Thanks again for the fab formula as its made my life a little easier.

Awaiting your response at the earleist

Cheers Ola

SandstorM


--
sandy.cariappa
------------------------------------------------------------------------
sandy.cariappa's Profile: http://www.excelforum.com/member.php...o&userid=23603
View this thread: http://www.excelforum.com/showthread...hreadid=372824