Date & time short cut

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

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" <ConditionalFormatting@discussions.microsoft.com>
wrote in message news:062206A9-3158-40B1-BD3D-BAA507CF142C@microsoft.com...
> 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