Furmlas for Time Card

New Member
I volunteered to work on a time card for a not for profit drug rehab center. It’s 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 it’s * 7.5 the regular worked hours for a day.

The headers and cell formulas I use for the sheet are:
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

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Replies
4
Views
418
Replies
4
Views
370
Replies
7
Views
636
Replies
0
Views
260
Replies
6
Views
434

1,196,412
Messages
6,015,113
Members
441,871
Latest member
lajervik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back