Need help by Timesheet

**FDibbins** · 02-06-2014, 08:23 PM

I am trying to work my way through your logic, row-by-row.

change the formula in column O to this...
=IF(V3=7,"",8/24) ("8:00" is text, not a number)

Change the formula in Q to this...
=IF(OR(N3="",O3>N3),"",N3-O3)

Change the formulas in R (all of them), to this...
=SUM($N$3:N3)

Once you have this done, let me know where the "errors" are

**MoFaSa** · 02-07-2014, 03:40 AM

@FDibbins
dear sir,

I have made some changes.
I HAVE Deleted colomn V

change the formula in column O to this...
=IF(V3=7,"",8/24) ("8:00" is text, not a number)

Colomn O - i change it to this
= MIN(N3;TIJD(8;0;0))

change the formula in column Q to this...
=IF(OR(N3="",O3>N3),"",N3-O3)

-formula is not working

transfer formula from Q to colomn P (125%)
=ALS(OF(N3>N3;O3="");"";N3-O3)

Change the formulas in colomn R (all of them), to this...
=SoM($N$3:N3)

working good.

Errors:
colomn P (marked in red)
Overtime in Holland is 125% for 2 hrs
after that 150% for 2 hrs. (colomn Q marked in red)

regards,
Mofasa

Map3-test.xlsm