Solved

Excel formula and formatting

Posted on 2013-05-09
3
157 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

691 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