Two formulas

G

Guest

is there any way to combined two
formulas


=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
 
G

Guest

Can anyone Help me?

When i said combined i meant have one forula and then
another one on the same line too.

Something like this
=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
 
Top