Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for a time card
I volunteered to work on a time card for a not for profit drug rehab center.
Its now beyond my knowledge base. Using Excel in Office 2003 with XP Pro. The time card has to allow for hour to be input on sick days, this is how it looks now. I have cells for M T W T F and I type in either the hour worked or S for sick days or V for vacation days taken. I would like to input on the sick days the hour worked if any. Sometimes they will go home after working just 4 hours or so. The formula I have now is: =COUNTIF(B6:H6,"S")*7.5. The B6:H6 range are the days of the week. The S indicates the sick day and its * 7.5 the regular worked hours for a day. The headers and cell formulas I use for the sheet a Hours worked =SUM(B6:H6) Stat holidays-manual input to cell unless there is a way to input automatically for Canadian stat holidays? Vacation time =COUNTIF(B6:H6,"V")*7.5 Sick time =COUNTIF(B6:H6,"S")*7.5 Hours sub-total =SUM(I6:L6) Lieu time earned =IF(M6=0,"",MAX(0,37.5-M6)) Lieu time used =-MIN(0,37.5-M6) Hours paid =SUM(M6,-N6,O6) Sick days 2005 hours used =+L6/7.5 Balance =+R5-Q6 Vacation 2005 Used =+K6/7.5 Balance =+T5-S6 Lieu Time over (Hours) TRACKING Earned =+N6, Used =+(O6) Balance =IF(ISERR(SUM(W5,U6,-V6)),"",SUM(W5,U6,-V6)) If anybody knows of a fix or a sheet that already does this type of output that would be great. I could sent the time card sheet if it would make things easier to figure out. Thanks in advance for any help |
#2
|
|||
|
|||
Formula for a time card
Hi
If you want to mail me direct with a copy of the sheet, I will take a look at it for you. Remove NOSPAM from my email address to send. Regards Roger Govier skateblade wrote: I volunteered to work on a time card for a not for profit drug rehab center. Its now beyond my knowledge base. Using Excel in Office 2003 with XP Pro. The time card has to allow for hour to be input on sick days, this is how it looks now. I have cells for M T W T F and I type in either the hour worked or S for sick days or V for vacation days taken. I would like to input on the sick days the hour worked if any. Sometimes they will go home after working just 4 hours or so. The formula I have now is: =COUNTIF(B6:H6,"S")*7.5. The B6:H6 range are the days of the week. The S indicates the sick day and its * 7.5 the regular worked hours for a day. The headers and cell formulas I use for the sheet a Hours worked =SUM(B6:H6) Stat holidays-manual input to cell unless there is a way to input automatically for Canadian stat holidays? Vacation time =COUNTIF(B6:H6,"V")*7.5 Sick time =COUNTIF(B6:H6,"S")*7.5 Hours sub-total =SUM(I6:L6) Lieu time earned =IF(M6=0,"",MAX(0,37.5-M6)) Lieu time used =-MIN(0,37.5-M6) Hours paid =SUM(M6,-N6,O6) Sick days 2005 hours used =+L6/7.5 Balance =+R5-Q6 Vacation 2005 Used =+K6/7.5 Balance =+T5-S6 Lieu Time over (Hours) TRACKING Earned =+N6, Used =+(O6) Balance =IF(ISERR(SUM(W5,U6,-V6)),"",SUM(W5,U6,-V6)) If anybody knows of a fix or a sheet that already does this type of output that would be great. I could sent the time card sheet if it would make things easier to figure out. Thanks in advance for any help |
#3
|
|||
|
|||
Formula for a time card
|
#5
|
|||
|
|||
Formula for a time card
Hi roger,
I tried again and just get this response: This is the qmail-send program at yahoo.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. : Sorry, I couldn't find any host named nospamtechnology4u.co.uk. (#5.1.2) I did remove the nospam but still unable to send the email. I also looked at the www.technology4u.co.uk but could not find were to send the email to. Now I feel totally computer aliterate. Any suggestion? Malcolm "Roger Govier" wrote: Hi Malcolm I said to remove nospam from the address. Just use the technology4u.co.uk Regards Roger Govier skateblade wrote: Hi Roger, Thanks for the response. I tried sending the a copy to your email address: But it was returned, what am I missing. Thanks for your time Malcolm "Roger Govier" wrote: Hi If you want to mail me direct with a copy of the sheet, I will take a look at it for you. Remove NOSPAM from my email address to send. Regards Roger Govier skateblade wrote: I volunteered to work on a time card for a not for profit drug rehab center. Its now beyond my knowledge base. Using Excel in Office 2003 with XP Pro. The time card has to allow for hour to be input on sick days, this is how it looks now. I have cells for M T W T F and I type in either the hour worked or S for sick days or V for vacation days taken. I would like to input on the sick days the hour worked if any. Sometimes they will go home after working just 4 hours or so. The formula I have now is: =COUNTIF(B6:H6,"S")*7.5. The B6:H6 range are the days of the week. The S indicates the sick day and its * 7.5 the regular worked hours for a day. The headers and cell formulas I use for the sheet a Hours worked =SUM(B6:H6) Stat holidays-manual input to cell unless there is a way to input automatically for Canadian stat holidays? Vacation time =COUNTIF(B6:H6,"V")*7.5 Sick time =COUNTIF(B6:H6,"S")*7.5 Hours sub-total =SUM(I6:L6) Lieu time earned =IF(M6=0,"",MAX(0,37.5-M6)) Lieu time used =-MIN(0,37.5-M6) Hours paid =SUM(M6,-N6,O6) Sick days 2005 hours used =+L6/7.5 Balance =+R5-Q6 Vacation 2005 Used =+K6/7.5 Balance =+T5-S6 Lieu Time over (Hours) TRACKING Earned =+N6, Used =+(O6) Balance =IF(ISERR(SUM(W5,U6,-V6)),"",SUM(W5,U6,-V6)) If anybody knows of a fix or a sheet that already does this type of output that would be great. I could sent the time card sheet if it would make things easier to figure out. Thanks in advance for any help |
#6
|
|||
|
|||
Formula for a time card
Hi Malcolm
The purpose of the email address being written this way is to prevent (if that is at all possible) the "name harvester software" that scans messages and picks up email addresses to send spam. If I write my email address out for you, it will defeat the objective of adding nospam to the email address in the first place rogerattechnology4u.co.uk replace the "at" with @ Regards Roger Govier skateblade wrote: Hi roger, I tried again and just get this response: This is the qmail-send program at yahoo.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. : Sorry, I couldn't find any host named nospamtechnology4u.co.uk. (#5.1.2) I did remove the nospam but still unable to send the email. I also looked at the www.technology4u.co.uk but could not find were to send the email to. Now I feel totally computer aliterate. Any suggestion? Malcolm "Roger Govier" wrote: Hi Malcolm I said to remove nospam from the address. Just use the technology4u.co.uk Regards Roger Govier skateblade wrote: Hi Roger, Thanks for the response. I tried sending the a copy to your email address: But it was returned, what am I missing. Thanks for your time Malcolm "Roger Govier" wrote: Hi If you want to mail me direct with a copy of the sheet, I will take a look at it for you. Remove NOSPAM from my email address to send. Regards Roger Govier skateblade wrote: I volunteered to work on a time card for a not for profit drug rehab center. Its now beyond my knowledge base. Using Excel in Office 2003 with XP Pro. The time card has to allow for hour to be input on sick days, this is how it looks now. I have cells for M T W T F and I type in either the hour worked or S for sick days or V for vacation days taken. I would like to input on the sick days the hour worked if any. Sometimes they will go home after working just 4 hours or so. The formula I have now is: =COUNTIF(B6:H6,"S")*7.5. The B6:H6 range are the days of the week. The S indicates the sick day and its * 7.5 the regular worked hours for a day. The headers and cell formulas I use for the sheet a Hours worked =SUM(B6:H6) Stat holidays-manual input to cell unless there is a way to input automatically for Canadian stat holidays? Vacation time =COUNTIF(B6:H6,"V")*7.5 Sick time =COUNTIF(B6:H6,"S")*7.5 Hours sub-total =SUM(I6:L6) Lieu time earned =IF(M6=0,"",MAX(0,37.5-M6)) Lieu time used =-MIN(0,37.5-M6) Hours paid =SUM(M6,-N6,O6) Sick days 2005 hours used =+L6/7.5 Balance =+R5-Q6 Vacation 2005 Used =+K6/7.5 Balance =+T5-S6 Lieu Time over (Hours) TRACKING Earned =+N6, Used =+(O6) Balance =IF(ISERR(SUM(W5,U6,-V6)),"",SUM(W5,U6,-V6)) If anybody knows of a fix or a sheet that already does this type of output that would be great. I could sent the time card sheet if it would make things easier to figure out. Thanks in advance for any help |
#7
|
|||
|
|||
Formula for a time card
Thanks for the effort I appreciate it.
It's now been sent and not returned. Thank you again. Malcolm "Roger Govier" wrote: Hi Malcolm The purpose of the email address being written this way is to prevent (if that is at all possible) the "name harvester software" that scans messages and picks up email addresses to send spam. If I write my email address out for you, it will defeat the objective of adding nospam to the email address in the first place rogerattechnology4u.co.uk replace the "at" with @ Regards Roger Govier skateblade wrote: Hi roger, I tried again and just get this response: This is the qmail-send program at yahoo.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't work out. : Sorry, I couldn't find any host named nospamtechnology4u.co.uk. (#5.1.2) I did remove the nospam but still unable to send the email. I also looked at the www.technology4u.co.uk but could not find were to send the email to. Now I feel totally computer aliterate. Any suggestion? Malcolm "Roger Govier" wrote: Hi Malcolm I said to remove nospam from the address. Just use the technology4u.co.uk Regards Roger Govier skateblade wrote: Hi Roger, Thanks for the response. I tried sending the a copy to your email address: But it was returned, what am I missing. Thanks for your time Malcolm "Roger Govier" wrote: Hi If you want to mail me direct with a copy of the sheet, I will take a look at it for you. Remove NOSPAM from my email address to send. Regards Roger Govier skateblade wrote: I volunteered to work on a time card for a not for profit drug rehab center. Its now beyond my knowledge base. Using Excel in Office 2003 with XP Pro. The time card has to allow for hour to be input on sick days, this is how it looks now. I have cells for M T W T F and I type in either the hour worked or S for sick days or V for vacation days taken. I would like to input on the sick days the hour worked if any. Sometimes they will go home after working just 4 hours or so. The formula I have now is: =COUNTIF(B6:H6,"S")*7.5. The B6:H6 range are the days of the week. The S indicates the sick day and its * 7.5 the regular worked hours for a day. The headers and cell formulas I use for the sheet a Hours worked =SUM(B6:H6) Stat holidays-manual input to cell unless there is a way to input automatically for Canadian stat holidays? Vacation time =COUNTIF(B6:H6,"V")*7.5 Sick time =COUNTIF(B6:H6,"S")*7.5 Hours sub-total =SUM(I6:L6) Lieu time earned =IF(M6=0,"",MAX(0,37.5-M6)) Lieu time used =-MIN(0,37.5-M6) Hours paid =SUM(M6,-N6,O6) Sick days 2005 hours used =+L6/7.5 Balance =+R5-Q6 Vacation 2005 Used =+K6/7.5 Balance =+T5-S6 Lieu Time over (Hours) TRACKING Earned =+N6, Used =+(O6) Balance =IF(ISERR(SUM(W5,U6,-V6)),"",SUM(W5,U6,-V6)) If anybody knows of a fix or a sheet that already does this type of output that would be great. I could sent the time card sheet if it would make things easier to figure out. Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert time (2:30) to a number (2.5) in a formula? | Excel Worksheet Functions | |||
Formula Needed for Transit Time | Excel Discussion (Misc queries) | |||
Time Date Formula Problem | Excel Worksheet Functions | |||
Formula for time? | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel |