Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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! |
#3
![]() |
|||
|
|||
![]()
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! |
#4
![]() |
|||
|
|||
![]()
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! |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Editing from Multiple computers? | Excel Discussion (Misc queries) | |||
capturing data on multiple students; keeping history; making chart | Excel Discussion (Misc queries) | |||
Capturing daily student ratings developing history | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) |