Excel formula and formatting

I am attaching a workbook to this for input/ suggestions.

Cell A2 is the total hours

Cell B2 is the working hours in a day, this # is put in manually

Cell C2 is the total # of days, not sure if the formula is correct

Cell D2 will be the # of workers assigned, this # is put in manually

Cell E2 will be the # of days required  to be on the project.

Hoping someone can share their suggestions for best solution to this need.
Who is Participating?
byundtConnect With a Mentor Commented:
Times are equivalent to decimal fractions. A value of 0.5 is equivalent to 12:00 PM (noon). Similarly, 0 is midnight--and so too is 1.0

Since you had 20 hours in cell A2 formatted as a time, but 8 (hours/day) in cell B2 formatted as a number--the correct calculation would be 20:00/(8/24) = 20:00 /8 * 24 or A2/B2*24

I then changed the formatting in C2 and E2 from Custom (time format) to Number format.

I changed the formatting on a couple of cells, plus the formula in cell C2.
FreddyBassAuthor Commented:
Thank you for your input Brad, apologize for the delay
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.