B
Bob
=IF(A30="","",SUM(C3:C25)*ROUNDUP(Worksheet2!G3/G1,0))
I only need to Sum (C3:C25) ONCE, Then after that, Sum (C3:C10) for
the remaining.
Example: If G3 lets say is 100 and G1 is lets say 25 then Sum C3:C25
only ONCE then Sum C3:C10 for the remaining count which is 75 in this
example.
C3:C25 is formatted as time, so is G4 where this formula is.
With this formula NOW it shows a total of 8 hours.
The way I need this formulas end result is to be 2.5 hours.
Thanks in Advance!!!
I only need to Sum (C3:C25) ONCE, Then after that, Sum (C3:C10) for
the remaining.
Example: If G3 lets say is 100 and G1 is lets say 25 then Sum C3:C25
only ONCE then Sum C3:C10 for the remaining count which is 75 in this
example.
C3:C25 is formatted as time, so is G4 where this formula is.
With this formula NOW it shows a total of 8 hours.
The way I need this formulas end result is to be 2.5 hours.
Thanks in Advance!!!