Ctrl-Shift-; (semi-colon) inputs the date and time.

Difference is just =B1-A1 formatted as time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Conditional Formatting"
wrote in message ...
Any help?

I'd like to input the real time with date

column a column b column c (duration)
11/22/05 9:55 11/22/05 10:00 0:05:00