Hello all. I am a novice Excel user, and cannot seem to locate the
source of my problem. Please help!


Here is my sheet:


C4 D4
E4 F4 G4 H4

9/22/2005 7:10 PM___10/1/2005 12:13 PM___ 8.7__52.6__6.0__317.64

Start date is entered into C4.
End date is entered into D4.

The following formula is in E4 to determine elapsed days:

=IF(D4=0,"",IF(C4=0,"",(IF(ISERROR((D4-C4)*24),"",(D4-C4)*24)/24)))

F4 contains "FLAGED HOURS" (for a body shop estimate)

G4 contains a value used for "cycle time" and is using the following
formula:

=IF(F4=0,"",F4/E4)

H4 contains a simple multiplication formula: =(F4*G4), but returns
317.64 INSTEAD of 315.6 (which is 52.6 x 6.0). I need the 315.6 result
in H4.

Would someone please tell me what I am doing wrong????

Thanks very much!


--
millzenator
------------------------------------------------------------------------
millzenator's Profile: http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490

The cells contain trailing digits which you are not seeing.

You could try

=(ROUND(F4,2)*(ROUND(G4,1)))

--
HTH

Bob Phillips

"millzenator"
wrote in message
...

Hello all. I am a novice Excel user, and cannot seem to locate the
source of my problem. Please help!


Here is my sheet:


C4 D4
E4 F4 G4 H4

9/22/2005 7:10 PM___10/1/2005 12:13 PM___ 8.7__52.6__6.0__317.64

Start date is entered into C4.
End date is entered into D4.

The following formula is in E4 to determine elapsed days:

=IF(D4=0,"",IF(C4=0,"",(IF(ISERROR((D4-C4)*24),"",(D4-C4)*24)/24)))

F4 contains "FLAGED HOURS" (for a body shop estimate)

G4 contains a value used for "cycle time" and is using the following
formula:

=IF(F4=0,"",F4/E4)

H4 contains a simple multiplication formula: =(F4*G4), but returns
317.64 INSTEAD of 315.6 (which is 52.6 x 6.0). I need the 315.6 result
in H4.

Would someone please tell me what I am doing wrong????

Thanks very much!


--
millzenator
------------------------------------------------------------------------
millzenator's Profile:
http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490

Well, I need more help on these sheets. I've made two attachments (I
wish I could figure out how to imbed an image directly into the message
here...)

On sheet 1, this is the code to figure the required date for a cycle
time. This is from column F-

=IF(C3=0,"",C3+(D3/E3))


This is the code from column G, that tells me how many days between C
and F-

=IF(F3=0,"",IF(C3=0,"",(IF(ISERROR((F3-C3)*24),"",(F3-C3)*24)/24)))

I need the formula to exclude Saturdays and Sundays. Is this possible?
If possible, it would be great to have it display " x days x hours"
instead of "5.8" days.

On sheet 3, I am using the same code-

=IF(D3=0,"",IF(C3=0,"",(IF(ISERROR((D3-C3)*24),"",(D3-C3)*24)/24)))

...to tell me how many elapsed days between C and D, and still need the
same fix, as above.

Please help!


+-------------------------------------------------------------------+
|Filename: sheet3.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4700 |
+-------------------------------------------------------------------+

--
millzenator
------------------------------------------------------------------------
millzenator's Profile: http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490

Try using Excel formula: =networkdays(start date,end date). You can even
exclude holidays using this formula. First, though, you have to go to Tools,
Add-Ins... and select the Analysis ToolPak. Takes about two seconds to do.
The Analysis ToolPak give you a choice of lots more formulas.

"millzenator" wrote:


Well, I need more help on these sheets. I've made two attachments (I
wish I could figure out how to imbed an image directly into the message
here...)

On sheet 1, this is the code to figure the required date for a cycle
time. This is from column F-

=IF(C3=0,"",C3+(D3/E3))


This is the code from column G, that tells me how many days between C
and F-

=IF(F3=0,"",IF(C3=0,"",(IF(ISERROR((F3-C3)*24),"",(F3-C3)*24)/24)))

I need the formula to exclude Saturdays and Sundays. Is this possible?
If possible, it would be great to have it display " x days x hours"
instead of "5.8" days.

On sheet 3, I am using the same code-

=IF(D3=0,"",IF(C3=0,"",(IF(ISERROR((D3-C3)*24),"",(D3-C3)*24)/24)))

...to tell me how many elapsed days between C and D, and still need the
same fix, as above.

Please help!


+-------------------------------------------------------------------+
|Filename: sheet3.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4700 |
+-------------------------------------------------------------------+

--
millzenator
------------------------------------------------------------------------
millzenator's Profile: http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490

I've tried incorporating the NETWORKDAYS function into the current
formulas, but can't get it to work. Playing with NETWORKDAYS on a
blank sheet, it rounds to the day. I need results to the hour. Any
further help, or examples using my formulas?

Thanks!

Terry


--
millzenator
------------------------------------------------------------------------
millzenator's Profile: http://www.excelforum.com/member.php...o&userid=28042
View this thread: http://www.excelforum.com/showthread...hreadid=475490

Can I confirm what you want to do?

Do you want to calculate the number of days and hours between two
date/times (excluding weekends) or do you want to generate a date/time
based on a number of days (possibly fractional) added to a start
date/time? (or both :) )

If the latter then how many hours constitute a day? If you add 1.2 days
to 18:00 on a Monday what should the result be? Do you want the time
returned to be any time of the day or should it be within specific
hours, e.g. your working hours, if so what are these?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=475490

This appears to be a rounding problem....Try changing the foemula in H:4
to =F4*ROUND(G4,0)


--
LGW
------------------------------------------------------------------------
LGW's Profile: http://www.excelforum.com/member.php...o&userid=28046
View this thread: http://www.excelforum.com/showthread...hreadid=475490