entering time in a spreadsheet

[Access Trainee]

Is is possible to enter time in a spreadsheet without using a semi-colon?

 

[Gary''s Student]

Yes:
Use a colon.

 

[Gord Dibben]

1. enter without a colon then use a helper cell to convert to time

2. Use event code to convert as you enter.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP