Formula for calculating individual employee YTD Working Hours

[EccaB]

Hi,

Newby here and hoping a guru might be able to assist with this question please. I've created a utilisation spreadsheet for a services business and I'm trying to work out a formula that calculates an indivudal employees available YTD Working Hours that takes into account their start date / last working day (where applicable) / current date / excludes weekends & public holidays (if possible) / standard 40 hour working week (Mon - Fri).

Any thoughts and suggestions much appreciated!

Thanks in advance!!
Bex

 

[Robert Mika]

Hi,

Newby here and hoping a guru might be able to assist with this question please. I've created a utilisation spreadsheet for a services business and I'm trying to work out a formula that calculates an indivudal employees available YTD Working Hours that takes into account their start date / last working day (where applicable) / current date / excludes weekends & public holidays (if possible) / standard 40 hour working week (Mon - Fri).

Any thoughts and suggestions much appreciated!

Thanks in advance!!
Bex

Hello and welcome to MrExcel.
Could you post your data?
Please see below how to do it.