Staff Holiday Analysis

Hi there, I am a new user on this forum and don't have much experience on excel. My boss wants me to take the holiday info from SAGE for 80 employees and create a record on excel. He wants to know what holidays each employee has taken and is due to take throughout the year. As each employee works a different amount of hours and a different shift pattern, SAGE records their holiday entitlement in hours rather than days. I have attached an example of one employees details and wonder if anyone can help me come up with an excel document containing similar information for 80 individuals - all starting on different dates and all having a different amount of holiday entitlement. He wants to be able to look at each employees record for the year and see not only holiday data but sick days too. I don't know where to start with this - I've thought about creating a workbook with 80 pages and create a 12 month calendar for each individual with days off marked on it?!?!? I really appreciate any help you are able to offer

Caroline,

I don't see your attachment.

Sorry - can't seem to work out how to send attachment. FAQ says use brows button but dont see one!!

Near the "Post Quick Reply" button is a "Go Advanced" button, hit that and scroll down, you'll see the attachment button. So many buttons...

Hi there, I am a new user on this forum and don't have much experience on excel. My boss wants me to take the holiday info from SAGE for 80 employees and create a record on excel. He wants to know what holidays each employee has taken and is due to take throughout the year. As each employee works a different amount of hours and a different shift pattern, SAGE records their holiday entitlement in hours rather than days. I have attached an example of one employees details and wonder if anyone can help me come up with an excel document containing similar information for 80 individuals - all starting on different dates and all having a different amount of holiday entitlement. He wants to be able to look at each employees record for the year and see not only holiday data but sick days too. I don't know where to start with this - I've thought about creating a workbook with 80 pages and create a 12 month calendar for each individual with days off marked on it?!?!? I really appreciate any help you are able to offer