Do you mean Chip Pearson's OT timesheet at

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

?

If so you need to explain what you added


You can use Chip's example of entering times w/o colon here

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


Regards,

Peo Sjoblom



"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!