Date & time short cut

[Guest]

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

 

[Bob Phillips]

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)