How to enter time without using the colon :

[jfiorini]

Hi I have to enter employee timecards and I have an excel file where I enter the start time, beginning of lunch, end of lunch and end time and it calculates hours worked for me. This is awesome and saves me time however, I have to enter the time in the HH:MM format, and having to enter the colon really slows me down. There's no colon on the 10-key pad! Is there anyway to use say a period instead?

[Macfool]

You can use this macro, just enter the time as you do now and it will insert the colon for you, just adjust the ranges to suit your columns.[FORMULA

Please Login or Register  to view this content.

[Paul]

If you want to use functions instead of macros, you could have helper columns. Let's say you enter Start Time in A2, Break Time in B2, Return from Break in C2 and End Time in D2. In E2 use something like:

=(INT(A2)+((A2-INT(A2))/0.6))/24

or

=TIME(INT(A2),(A2-INT(A2))*100,0)

Fill that to the right (into F2, G2 and H2) to get the time values for the data you entered. (Format cells as Time, of course.)

You can then do calculations/totals/etc. on columns E:H.

[martindwilson]

i'd remap my keyboard an put : instead of del on the numeric key pad!
http://vlaurie.com/computers2/Articl...p-keyboard.htm