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