timesheet
I use this formula at F5 to calculate hours worked etc:
=IF(OR(D5="A/L",D5="SICK"),8,IF(D5="","0",((E5-D5)+(E5<D5))*24)-0.5) How do i get a nil or blank result if there's no hours worked that day (currently i get a -0.5) many thanks andy |
timesheet
Try this:
=IF(OR(D5="A/L",D5="SICK"),8,IF(D5="","0",(((E5-D5)+(E5<D5))*24)-0.5)) Regards, Per "Andy Bolger" skrev i meddelelsen ... I use this formula at F5 to calculate hours worked etc: =IF(OR(D5="A/L",D5="SICK"),8,IF(D5="","0",((E5-D5)+(E5<D5))*24)-0.5) How do i get a nil or blank result if there's no hours worked that day (currently i get a -0.5) many thanks andy |
timesheet
=IF(OR(D5={"A/L","SICK"}),8,IF(COUNT(D5:E5)=2,(E5-D5+(E5<D5))*24-0.5,""))
"Andy Bolger" wrote: I use this formula at F5 to calculate hours worked etc: =IF(OR(D5="A/L",D5="SICK"),8,IF(D5="","0",((E5-D5)+(E5<D5))*24)-0.5) How do i get a nil or blank result if there's no hours worked that day (currently i get a -0.5) many thanks andy |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com