Holiday Chart Views

DawkiT

New member
Joined
May 2, 2012
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Excel for 365
Hi,
I'm sure there must be an easy way of doing this, but I can't for the life of me work it out. I have a holiday chart for 40 employees that calculates how many days they have taken and how many they have left to take before a certain date, so the cells already have basic formulas. The chart is populated with the results in hours, however what I would like to do is to have a button or drop down box showing hours or days, which then changes to show the results in days, and back to hours as required by any user. The guys work a 7.4 hour day, so basically it needs to divide every cell by 7.4. I know I can do this by having a separate table but that gets messy.
Any help would be appreciated.
Cheers
 
Top