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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks