Hello,
I have a holiday spreadsheet.
We are entitled to 200 hours annual leave overall which works out as 25days(8hr days)(Mon-Thursday). But, if you only took Fridays then you could have 40 days as one Friday annual leave is only 5hrs leave and not the 8hrs.
We are also allowed to take 2hrs off if we wish.
I am looking for help with a formula that works out how much days and hours I have left available to take.
My spreadsheet allows me to enter in the start date, end date which works out the number of days(but i need to disregard weekend days) and I can add in how many hours. So,
For example.
Start Date End Date Reason Number of Hrs Number of Days
23 May 2017 25 May 2017 Wedding 8.0(maybe should read 24?) 3
Subtracting the hours is the easy part but not sure how I get it to display that I have not actually taken a full day(overall) if it is less than 8hrs?
Also, it probably should display half days which would be 4hrs.
Hope fully I have attached the spreadsheet correctly.
Thanks
Ross
Bookmarks