Using an IF statement on time based data
DonB-
Now that I think on it a little longer, your original formula appears
to have a logic flaw in it. Your formula says
=if(((d12-c12)+(f12-e12)+(h12-g12))=8,8
.... which would award someone with 8 hours' work if they worked
anything less than 8.
|