ExcelBanter - Date & time short cut

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date & time short cut (https://www.excelbanter.com/excel-worksheet-functions/56550-date-time-short-cut.html)

Conditional Formatting

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

Bob Phillips

Date & time short cut

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

All times are GMT +1. The time now is 07:23 PM.