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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top