melhay explained on 3/12/2012 :
Thank you for taking the time to respond. I can see a couple of issues
(staff work out in the field and we may not know they are off sick until
some time the next month, so clearing the sheet could be problematic,
and we need to collate half days as well, so a date may not work) - but
I will certainly see if I can incoporate some of your concepts.

You could easily include a column for duration that uses hours or
decimal fraction of a workday's normal shift duration. For example...

Hours:
4.5

Days: (based on 8-hour shift)
=8/4.5

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion