Another option would be to use an event macro that fixes your data entry.

If you want to try, check out Chip Pearson's site:
http://cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Margaret RM wrote:

Hello, I have to enter thousands of time card values (7:45, 15:13 etc).
After a few thousand of these entries my hand is tired - especially when I
have to do a Shift + ; for each time entry. I have a Microsoft Natural
keyboard and cannot figure out how to re-set another key - such as the F12 or
the Calculator key to be the : . Any ideas??? Thanks

--

Dave Peterson