Date & time short cut

  • Thread starter Conditional Formatting
  • Start date
C

Conditional Formatting

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
 
B

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)
 
Top