Solved

Excel formula and formatting

Posted on 2013-05-09
3
150 Views
Last Modified: 2013-05-27
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
Comment
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
  • Learn & ask questions
  • 2
3 Comments
 
LVL 81

Expert Comment

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

Accepted Solution

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

Brad
0
 

Author Closing Comment

by:FreddyBass
ID: 39199461
Thank you for your input Brad, apologize for the delay
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question