have looked online for answer to question and have tried doing the suggested fixes such as
as for the shift PM i need to look for when it was reported and if its = or after 15:00 then i want it to calculate if not then ignore the time taken column
Please Login or Register to view this content.
same for NIght shift but for this it will be looking at time reported = or greater then 23:00
and for AM it will between 07:00 & 15:00
thanks for any help
cheers
Last edited by murray83; 04-09-2017 at 02:57 AM. Reason: incomplete title
I think you didn't quite complete your thread title - please edit your original post, using the Go Advanced option, to complete it. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
1. you should include some sample answers to give us an idea what you want
2. if you need to zip the file to upload, then it is too big for what we need - we only need a small sample file, showing what you have, and what you want
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ok have fixed the file size
and have managed to half fix the night shift but not sure why the top cell is blank
Last edited by murray83; 04-09-2017 at 03:05 AM.
Can you not zip it up? That's a pretty hefty workbook!
u serious its 11.3 KB ??
the file uploads fine for me
Well, before you edited your post, you were quoting 3.4MB ...Originally Posted by murray83
In G2
=IF(B7>23/24,SUM(G7:G654),"")
tried that formula doesn't fault which is good but see attached for
results ( night shift image )
also look at PM Shift image for what i have done but again just a blank smegging cell
You can try below formulas :
On E2 :
Formula:
Please Login or Register to view this content.
On F2 :
Formula:Please Login or Register to view this content.
On G2 :
Formula:Please Login or Register to view this content.
you clever clever person works like an absolute charm
cheers
Glad to help you and thanks for the rep.
your welcome and thanks for your continued help
You forgot to adjust the array length. You used C7:C250 where all others are 7:654. The length should be same there.
On E3 :
Formula:Please Login or Register to view this content.
On F3 :
Formula:Please Login or Register to view this content.
On G3 :
Formula:Please Login or Register to view this content.
stella, thanks works
shall stop bothering you
Who's Stella?
We're all here to help, but I'm not quite sure how I helped you this time. Thanks for the rep, though!
Glad to hear that it worked. Don't hesitate to ask again. Because you were not bothering me. Actually when We help others it helps us for our personal development. So we are always there for ourselves.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks