need a formula to calculate data

[imported_unknown]

I work as an office admin employees work a four shift sytem on a 28 day basis. If a person works today was sick yesterday did not work previous day need formula to calculate work particulars around sick period.




hope somebody can help


Liam
This message was edited by liam on 2002-10-06 07:06
This message was edited by liam on 2002-10-06 07:22

 

[Dexter]

Liam,

I think you'll need to supply some additional detail about your question.

Dexter

 

[WillR]

do you have email??? if so, i developed a John Walkenbach timesheet file from a weekly to a monthly timesheet that calculates holiday, sickness etc and would quite happily e-mail it to you tomorrow when i'm at work....
Alternatively, if you need to do this today, try visiting the site and seeing if the original is of any use....

http://j-walk.com/ss/excel/files/timesht.htm

hth

(if you have e-mail and want my file, email me tomorrow on william.riley@unitygroup.co.uk)