Donna, I reviewed the answer including the vba/macro scripting. That, if you
can take the time to learn it, is the most elegant. My method is humble, but
it works.

Click Tools, make sure the menu fully expands and then select "autocorrect
options". In the first box type two symbols that you will never use in a
formula. IN my case it is "**" (without the quotes obviously). In the second
box, type a colon.

Hope this helps.
Phil

"DonnaP99" wrote:

I have downloaded Pearsall's timesheet, which is wonderful. However, I need
to have 3 sets of In/Out columns. I added the two additional columns, but
now can't figure out how to correct the calculations.

Also, is it possible to input the data without needing to use a colon? I
don't care if I'd have to use military times. I have a ton of times to
enter, and using only the numeric keypad would be most efficient.

Thanks!