| 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 | |||
Linear Mode
