Solved

# Excel formula and formatting

Posted on 2013-05-09
153 Views
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.
TestWorkbook.xlsx
0
Question by:FreddyBass
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 81

Expert Comment

ID: 39154097
I changed the formatting on a couple of cells, plus the formula in cell C2.
TestWorkbookQ28123848.xlsx
0

LVL 81

Accepted Solution

byundt earned 500 total points
ID: 39154110
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.

0

Author Closing Comment

ID: 39199461
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month6 days, 3 hours left to enroll