formula help

i need some help please. I know a little bit about excel,
but im having some trouble combining formulas.

this is what is in cell G13
=IF
(G10+G11+G12+F11+F10+E11+E10+D11+D10+C10+C11=40.0 1,G12+G11
+G10-G14,G10+G11+G12)

i want to also use this below formula to make G13 answer
with a number that roles over at .60

=INT(K14)+HOUR(MOD(K14,1)/14.4)+(MINUTE(MOD
(K14,1)/14.4)/100)

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

-----Original Message-----
i need some help please. I know a little bit about excel,
but im having some trouble combining formulas.

this is what is in cell G13
=IF

(G10+G11+G12+F11+F10+E11+E10+D11+D10+C10+C11=40.0 1,G12+G11
+G10-G14,G10+G11+G12)

i want to also use this below formula to make G13 answer
with a number that roles over at .60

=INT(K14)+HOUR(MOD(K14,1)/14.4)+(MINUTE(MOD
(K14,1)/14.4)/100)

.

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





-----Original Message-----
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

-----Original Message-----
i need some help please. I know a little bit about
excel,
but im having some trouble combining formulas.

this is what is in cell G13
=IF


(G10+G11+G12+F11+F10+E11+E10+D11+D10+C10+C11=40.0 1,G12+G11
+G10-G14,G10+G11+G12)

i want to also use this below formula to make G13 answer
with a number that roles over at .60

=INT(K14)+HOUR(MOD(K14,1)/14.4)+(MINUTE(MOD
(K14,1)/14.4)/100)

.

.

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.

-----Original Message-----
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





-----Original Message-----
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

-----Original Message-----
i need some help please. I know a little bit about
excel,
but im having some trouble combining formulas.

this is what is in cell G13
=IF



(G10+G11+G12+F11+F10+E11+E10+D11+D10+C10+C11=40.0 1,G12+G11
+G10-G14,G10+G11+G12)

i want to also use this below formula to make G13
answer
with a number that roles over at .60

=INT(K14)+HOUR(MOD(K14,1)/14.4)+(MINUTE(MOD
(K14,1)/14.4)/100)

.

.

.

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)


-----Original Message-----
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.

-----Original Message-----
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





-----Original Message-----
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

-----Original Message-----
i need some help please. I know a little bit about
excel,
but im having some trouble combining formulas.

this is what is in cell G13
=IF




(G10+G11+G12+F11+F10+E11+E10+D11+D10+C10+C11=40.0 1,G12+G11
+G10-G14,G10+G11+G12)

i want to also use this below formula to make G13
answer
with a number that roles over at .60

=INT(K14)+HOUR(MOD(K14,1)/14.4)+(MINUTE(MOD
(K14,1)/14.4)/100)

.

.

.

.