HI,
In cell K12 I have this formula: =IF(AND(B12<0,0625;B12<>"");B12;"") which gets its info from cell B12 assuming I start work earlier than 01:30.
In cell L12 I have this formula: =IF(AND(B12<0,0625;B12<>"");0,0625;"") which only writes 01:30 if B12 is earlier than 01:30
In cell M12 this is the formula: =IF(COUNT(K12:L12)=2;MOD(L12-K12;1);"") which works out the time difference between K12 and L12.
I want to delete the column 'M' as it is meaningless, I mean if I start work before 01:30 the overtime is always calculated untill 01:30 so I dont need it on the sheet.
How can I modify the formula's to always calculate time worked before 01:30 without having a column with 01:30 in it.
Thanks for any help
Alan
In cell K12 I have this formula: =IF(AND(B12<0,0625;B12<>"");B12;"") which gets its info from cell B12 assuming I start work earlier than 01:30.
In cell L12 I have this formula: =IF(AND(B12<0,0625;B12<>"");0,0625;"") which only writes 01:30 if B12 is earlier than 01:30
In cell M12 this is the formula: =IF(COUNT(K12:L12)=2;MOD(L12-K12;1);"") which works out the time difference between K12 and L12.
I want to delete the column 'M' as it is meaningless, I mean if I start work before 01:30 the overtime is always calculated untill 01:30 so I dont need it on the sheet.
How can I modify the formula's to always calculate time worked before 01:30 without having a column with 01:30 in it.
Thanks for any help
Alan