timesheet - deduct value from calculated cell

Hi guys...

I have timesheet which is almost perfect for me but it needs to be little more perfect

Examlple is attached...so I need this:

if there is a value in cell P6 I need it to substract from M6 cell....that is not a problem but I need it to show only values 0+....and if its below zero or equals zero, I need it to show empty cell like it is now...but I just need to add this formula to cell M6 which is calculated from cells J6 and L6...

and if P6 is empty, just do nothing..basically i dont want to show any zero values in my timesheet...

Thanks in advance....

if you're not sure of something just ask me timesheet__.xls

What formula you mean?

the formula I'm using at the moment is in column M...thats the column I need to edit

Originally Posted by Fotis1991

Hi

In which Column, is the formula that you use? Column L??

Hmm...why should I change column I5?...I5 has nothing to do with my calculation for cell M5...cells involved are J, L, M, Q...here is quote which is in column M and which needs to be changed: =IF(OR(J5=L5;ISERROR(J5-L5));"";J5-L5)

or did I explained something wrong?....

I need to deduct column Q from column M where is formula I posted. All the current conditions must apply

Originally Posted by Fotis1991

Hi, again.

In I5 and copy down, try this formula.

=IF(TIME(TRUNC(H5/100);MOD(H5;100);0)=0;"";TIME(TRUNC(H5/100);MOD(H5;100);0))

In this case, you will see NO zeroes. Just Empties cells.

Hope, that helps you.

Well...you're right...

its Column M it works fine how it is....but I just need to add -Q to that formula

Originally Posted by Fotis1991

I don't know if you did not explain, well, or i did not understand well....

For both of us, English is not, our first launquage.!

So, is Column Q, that you need to don't show 0??

=IF(OR(J5=L5;ISERROR(J5-L5));"";J5-L5)-Q5

returns #VALUE

under conditions, that if result in column M equals zero, its not gonna be visible...

Originally Posted by Fotis1991

...Under which condition??

Just(your formula in M5)- Q5?

Still need to sort this out...any more ideas?

Thanks

In this example I need cell M6 to equal 0:00 and displayed as empty cell...basicaly thats all I need

timesheet__.xls

OK..so once again

timesheet__.xls

Originally Posted by Fotis1991

Hi

I am not able to open your new attachment(and as i see, noone can until now).

Pls, try again.