Hello!
Never mind, solved it! :D
Hello!
Never mind, solved it! :D
Last edited by blaze182; 08-28-2014 at 07:41 AM.
1) SUM(8-A6), SUM is not required. This should simply be 8-A6.
2) AND(B6>18, SUM(24-B6))
is a LOGICAL test. It will produce TRUE or FALSE (1 or 0).
So whatever the first part of the formula works out to be you'll just be adding 1 or 0 to the result. I;m sure that's not what you want.
3) Assuming A6 is the number of hours (0-23) try
=IF(A6<8,8-A6,0)+IF(B6>18,B6-18,0)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank-you Special-K!
This was what I ended up with in the end:
=IF(A5<8, SUM(8-A5))+IF(B5>18, SUM((B5-24)+6))
I realised I had another error which is why I had to swap the second part around but it works now.
When should SUM be used opposed to a raw calculation?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks