G
Green Wizard
Working on weekly Rota. I have a formula for calculating hours thanks to
http://www.cpearson.com/excel/DateTimeWS.htm
but need to add to this for Bank Holidays, absences etc. So, if "Ann's"
week included a bank holiday on Monday, the Rota for this day will have
a "B" in the first of Monday's 2 columns (representing start & end
times) and "H" in the second. This paid day equates to 7 hours so how
do I make "B" and "H" each represent 3.5 hours? (or is there a much
much easier solution to the whole thing? Please say yes...) Any help
greatly appreciated.
Barney
http://www.cpearson.com/excel/DateTimeWS.htm
but need to add to this for Bank Holidays, absences etc. So, if "Ann's"
week included a bank holiday on Monday, the Rota for this day will have
a "B" in the first of Monday's 2 columns (representing start & end
times) and "H" in the second. This paid day equates to 7 hours so how
do I make "B" and "H" each represent 3.5 hours? (or is there a much
much easier solution to the whole thing? Please say yes...) Any help
greatly appreciated.
Barney