Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DonnaP99
 
Posts: n/a
Default Timesheet with multiple in/out daily

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
DonnaP99
 
Posts: n/a
Default

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Timesheet with multiple in/out daily

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 04:45 AM
Editing from Multiple computers? inspectorgadget Excel Discussion (Misc queries) 2 December 23rd 04 07:52 PM
capturing data on multiple students; keeping history; making chart mgrady Excel Discussion (Misc queries) 0 December 13th 04 10:21 PM
Capturing daily student ratings developing history mgrady Excel Discussion (Misc queries) 0 December 13th 04 09:57 PM
How do I avoid saving multiple Excel/Wordfiles for versioning purp Neil Excel Discussion (Misc queries) 1 December 13th 04 01:57 PM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"