time

[flkULCHAR]

i AM CONSTANTLY ENTERING THE TIME OF DAY INTO MY
SPREADSHEET,

e.g. 11:54pm

Is there a quick way...so I only need type

2354 and NOT '23 ":" 54 "PM" '

I am looking for speed.

thanks,

larry

 

[Frank Kabel]

Hi Larry
this can only be done with the help of VBA to parse your input. Have a
look at
http://www.cpearson.com/excel/DateTimeEntry.htm
for a possible way do achieve this

Frank

 

[Samir Kapadia]

Try this Ctrl + Shift + :