Hi there,
Please see attachment. The formula I have in cell P19 give the correct figure when the hours worked are inserted, but how do I get rid of #VALUE? I would like the cell to remain clear.
Regards
Princessd
Hi there,
Please see attachment. The formula I have in cell P19 give the correct figure when the hours worked are inserted, but how do I get rid of #VALUE? I would like the cell to remain clear.
Regards
Princessd
Last edited by princessd; 09-11-2008 at 01:01 PM. Reason: attachment added
No Attachment...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Your formula is not exactly right...
you are trying to multiply a blank by 24...
Try changing formula in P16 to:
=IF(D16="","",(D16-"20:00")*24)
copied down.
Hi,
I have tried that but it is giving me a figure before any hours worked are inputted.
Princessd
See attached
Oh... I'ved tried it again and it works... thank you very much for your time!
Sorry I we both responded at the same time.
Regards
Princessd
Last edited by princessd; 09-11-2008 at 01:25 PM.
The *24 needs to be inside the parentheses, otherwise 24 is being multiplied by "" when applicable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks