Entering Time in an Excel Spreadsheet

[John Baumgartner]

I am very keypad oriented and wish to enter the time of
day in the form of hh.mm rather than the traditional hh:mm

How do I format the cell to accept the period rather than
the : and still know that I mean the time of day.

I am using a 24 hour day format. Later I will ask Excel
to subtract the starting time from the ending time and
calculate the hours worked.

 

[Peo Sjoblom]

Leave the period out and look here at Chip Pearsons site

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

Another options might be to use autocorrect and replace a period by a colon
then change back after you done the time entries