G
Guest
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.01,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)
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.01,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)