Calculate Days from hours

[ExcelRoy]

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

Many thanks for any help

 

[Rick Rothstein]

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

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...

=ROUNDUP(120/8.2,)

 

[ExcelRoy]

Hi Rick,

Many thanks for the help. Does this count only working days (ie mon-fri)

Thanks again

 

[Rick Rothstein]

Hi Rick,

Many thanks for the help. Does this count only working days (ie mon-fri)

It assumed the 120 hours were all working hours in total.

 

[ExcelRoy]

Hi Rick,

Lets say from Today, I would need the formula to account for the 120 hours in days excluding Saturday and sundays

if possible of course

Thanks

 

[Rick Rothstein]

Hi Rick,

Lets say from Today, I would need the formula to account for the 120 hours in days excluding Saturday and sundays

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).