Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timesheet | Excel Discussion (Misc queries) | |||
Timesheet help | Excel Discussion (Misc queries) | |||
Timesheet - | Excel Discussion (Misc queries) | |||
Timesheet | Excel Worksheet Functions | |||
timesheet | Excel Worksheet Functions |