You did not say what cell these numbers are in, so you will need to replace the hard-coded numbers in this formula with the cell addresses for the cells containing them...Hi all,
I am looking for a way to calculate how many working days there are in 120 hours if a day is 8.2 hours long
It assumed the 120 hours were all working hours in total.Hi Rick,
Many thanks for the help. Does this count only working days (ie mon-fri)
Still not clear to me. Are those 120 working hours for which you don't want to assume any of them for Saturdays or Sundays or 120 24-hour days 8.2 of which are work hours? I think you might make things clearer for us if you assume today (January 18th) as the starting date and tell us what you expect the answer to be for those 120 hours (then we can work out from that what calculation to give to you).Hi Rick,
Lets say from Today, I would need the formula to account for the 120 hours in days excluding Saturday and sundays