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!

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!

Yes, that's the one. I copied the "Lunch In" and "End" columns and inserted
the duplicate cells to shift cells to the right. Then I renamed the columns
In - Out - In - Out - In - Out. The formula is ignoring the cells I added in
the calculation of total hours.

I've just looked at http://www.cpearson.com/excel/DateTimeEntry.htm. While
I'm sure it works, it is entirely greek to me. I have no idea even where to
begin with what that is. There is no one in my office here to help me with
it, and there is no software support personnel. Any suggestions with that,
since I don't know what to do?

TIA!

Donna




"Peo Sjoblom" wrote:

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!

Here's a description how to install a macro

http://www.mvps.org/dmcritchie/excel/install.htm

another way would be do toolsautocorrect, replace a period with a colon,
that way you can use the numeric keypad and type in a time like

09.05 and it will come out as 09:05, just remember to delete the autocorrect
when you are done or it will have an effect other applications as well as
excel

If you want in out in out in out you need to add that in the formulas, like
if you added 2 columns to the right of the old ones, then use something like

=((H4-C4+(H4<C4))-(G4-F4+E4-D4)+(G4<D4))*24

that is final end time minus start time, - (out2-in2+out1-in1)


Regards,

Peo Sovblom





"DonnaP99" wrote:

Yes, that's the one. I copied the "Lunch In" and "End" columns and inserted
the duplicate cells to shift cells to the right. Then I renamed the columns
In - Out - In - Out - In - Out. The formula is ignoring the cells I added in
the calculation of total hours.

I've just looked at http://www.cpearson.com/excel/DateTimeEntry.htm. While
I'm sure it works, it is entirely greek to me. I have no idea even where to
begin with what that is. There is no one in my office here to help me with
it, and there is no software support personnel. Any suggestions with that,
since I don't know what to do?

TIA!

Donna




"Peo Sjoblom" wrote:

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!

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!