Hi
I should start with - I'm a beginner at generating reports in excel.

I need to create a staff attendance exception report. For example the Default reg hours - 7.0 hours a day. However if they have taken half a day (3.5 ) vacation, then I need the Default hours zero'd out and a new field also named Reg. hours created that now has 3.5 hours in it.

From that I need to generate a monthly report for each person of all the hours that are different from the Default reg. hours. ie vacation, training, compassionate etc.

Can this be done in excel??

Any help would be appreciated.