If starting time is 3:20:35pm use the formula, =TIME(15,20,35)
and custom format the cell h:mm:ss AM/PM. Excel uses military time.

"karim" wrote in message
...
i want to record start time and end time multiple times on single worksheet
without using macro. Pls suggest any formula for same as =now() does not
help.

karim.


"ozgrid.com" wrote:

????????????????????



--
Regards
Dave Hawley
www.ozgrid.com
"karim" wrote in message
...
hi,

i want to create excel sheet wherein time has to be recorded multiple
time.
Now() formula does not help and i don't want to use macro.
Pls Suggest