scheduled hours

i'm using this formula to track hours but need to know how to fix it to were if hours equal zero then it puts off that day
=SUMPRODUCT((A3:A29="shellie")*(E3:E29-C3:C29+(C3:C29>E3:E29)))*24

Not sure what you mean. You get an error or the wrong result? In what circumstances exactly, i.e. which values in which cells?

One possibility....

=SUM(IF(A3:A29="Shellie",IF(ISNUMBER(C3:C29+E3:E29),MOD(E3:E29-C3:C20,1))))*24

This is an "array formula" which needs to be confirmed with CTRL+SHIFT+ENTER

what it is if shellie doesn't work on certain day it will only show 0 i want it to show that shellie is off that day not a 0

you could custom format the result cell like this

[=0]"Off";General

i'm kinda new to this all, kinda uncertain on how to do a custom format.

Say you have your SUMPRODUCT formula in D30 then select that cell and then select the "Format" menu from the toolbar at the top then

Cells > Number > Custom

and type or paste exactly waht I suggested in the box, i.e.

[=0]"Off";General

OK

thanks for all your help