formula help

[Frank Kabel]

Hi
first I would simplify your first formula to something like
=SUM(G10:g12)-G14*((SUM(C10:G11)+G12)>40.01)

Now if I uinderstood you correctly just insert this
formula instead of K14 in your other formula

 

[Guest]

okay thank you for helping simplify the first formula.
But i still have the problem of numbers over .59 i would
like every cell to role over to a whole number when it has
a value of .60 example .75 = 1.15

do i need to add an additional formula to what ever my
first formula is in each cell.

I was using this formula in L14 to change cell k14
=INT(K14)+HOUR(MOD(K14,1)/14.4)+(MINUTE(MOD
(K14,1)/14.4)/100) but this isn't going to work i need to
have the whole sheet compute on a 60 minute basis.

how can i get every cell in my sheet to compute .60 = 1
and .61 = 1.01 and any thing under .59 is the aloud to be
anything below .59

 

[Frank Kabel]

Hi
the easiest way would be to store the values not as
decimal values but as time values. e.g. enter them with
0:0:51

this way Excel takes care of this rollover. Otherwise you
would have to add specific formulas to convert your
entries for each single cell. So you can't change the
calculation globally.

 

[Guest]

if it means putting a formula in each cell to convert its
self to have answers that role over to a whole number
at .60 i will do it. is there any way to combined two
formulas if so this might work.


=SUM(G10:g12)-G14*((SUM(C10:G11)+G12)>40.01)

=INT(G10:G12)+HOUR(MOD(G10:G12,1)/14.4)+(MINUTE(MOD
(G10:G12,1)/14.4)/100)