LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Formatting question with Round

I have a Proposal, in the proposal there is a sheet that gathers the the
facility upgrade cost, production man hours, by building and other info.

One thing I need for this sheet to do is take the Production hrs per
building and calculate installation days per building. Here is the formula I
am using:

=IF(E5<6,1,ROUND(E5/($F$3*8)*1.3,0))

In this case:

E5 is (7.9) Production Hrs By Building and is gathered from the Costing Tab
or Sheet in the Proposal

F3 is estimated crew size of (3) and is gathered from the Costing Tab or
Sheet in the Proposal

Currently I am getting irratic calculations shown below. I would like for it
to show a part of a day if it is 7.9 hours to do the job and there are 3 men
working 8 hours a day it should show something like 0.34 intallation time day
with a Safety Factor.

Production Hrs By Bldg Installation Time (Days) with Safety Factor
E5 7.9 0.0
E6 0.8 1.0
E7 3.2 1.0
E8 6.4 0.0
E9 3.3 1.0
E10 19.5 1.0

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Round-Up question PFLY Excel Discussion (Misc queries) 2 September 9th 09 04:40 PM
Round-Up question Pete_UK Excel Discussion (Misc queries) 0 September 9th 09 04:39 PM
Formatting Question Jared Excel Discussion (Misc queries) 1 July 13th 06 08:29 PM
formatting question Helen Excel Discussion (Misc queries) 3 February 1st 06 03:53 AM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 10:50 AM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"