If statement between times and days

Hi everyone,

I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times.

Mon – Fri: 17:00 – 19:59 = 1

Mon – Fri: 20:00 – 23:59 = 1.5

Mon – Sat: 00:00 – 08:30 = 2

Sat: 08:30 – 23:59 = 1.5

Sun 00:00 – Mon 08:30 = 2

I’ve tried using the following formula, but get a “False” output.

=IF(AND(C8>=TIMEVALUE(“17:00”))*(C8<=TIMEVALUE(“19:59″)),”1”,IF(AND(C8>=TIMEVALUE(“20:00”))*(C8<=TIMEVALUE(“23:59″)),”1.5”,IF(AND(C8>=TIMEVALUE(“00:00”))*(C8<=TIMEVALUE(“08:29″)),”2”)),IF(AND(C8>=TIMEVALUE(“08:30”))*(C8<=TIMEVALUE(“17:00″)),”1.5”)))

Thank you for your help!

J

By: James

45 thoughts on “If statement between times and days

  1. Ephedrine online bestellen

    Very great post. I simply stumbled upon your weblog and wanted to say that I have really enjoyed surfing around your weblog posts. In any case I will be subscribing to your feed and I am hoping you write once more very soon!

  2. anabolika kaufen

    Hey, I think your website might be having browser compatibility issues. When I look at your blog site in Firefox, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!

  3. spritze anabole steroide kaufen

    What i don’t understood is in truth how you are no longer actually much more smartly-appreciated than you may be now. You are so intelligent. You realize therefore significantly relating to this matter, made me in my view believe it from so many numerous angles. Its like women and men don’t seem to be fascinated unless it’s one thing to accomplish with Lady gaga! Your individual stuffs nice. Always maintain it up!

  4. Acheter Reductil France

    An attention-grabbing dialogue is worth comment. I feel that you need to write more on this matter, it might not be a taboo subject but generally people are not sufficient to talk on such topics. To the next. Cheers

  5. Phentermine bestellen

    Hi there! This post couldn’t be written any better! Reading through this post reminds me of my previous room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thank you for sharing!

  6. anabolika kaufen

    What i do not understood is actually how you’re not actually a lot more smartly-liked than you might be right now. You are very intelligent. You understand thus considerably relating to this matter, made me personally imagine it from so many varied angles. Its like women and men are not involved except it is one thing to accomplish with Woman gaga! Your individual stuffs great. At all times care for it up!

  7. adipex kaufen

    I have been absent for some time, but now I remember why I used to love this website. Thank you, I will try and check back more often. How frequently you update your website?

  8. CBD Topicals Cream

    Hello, i think that i saw you visited my web site so i came to “return the favor”.I’m trying to find things to improve my website!I suppose its ok to use a few of your ideas!!

  9. ig

    I think that is one of the so much significant information for me.
    And i’m satisfied reading your article. However wanna observation on some common issues, The site style is ideal, the articles is
    truly great : D. Good activity, cheers

  10. bbs.3see.com

    I just like the helpful information you supply to your articles.
    I will bookmark your blog and take a look at again here regularly.
    I’m moderately sure I’ll be told a lot of new stuff
    proper here! Good luck for the following!

  11. market trends 2018

    Definitely consider that that you said. Your favorite justification seemed to be on the internet the simplest thing to take note of. I say to you, I definitely get annoyed at the same time as folks think about concerns that they plainly don’t recognize about. You managed to hit the nail upon the top as well as defined out the entire thing without having side effect , people can take a signal. Will probably be back to get more. Thank you

  12. sse composite index

    Thanks , I’ve recently been looking for information approximately this topic for a while and yours is the best I have found out so far. However, what about the conclusion? Are you positive in regards to the supply?

  13. try this website

    Thanks, I have just been searching for info approximately this subject for a long time and yours is the greatest I have came upon so far. But, what in regards to the conclusion? Are you sure concerning the source?

  14. Newton Duncklee

    Hello, you used to write excellent, but the last several posts have been kinda boringK I miss your super writings. Past few posts are just a little bit out of track! come on!

  15. Vincenzo Mozley

    hey there and thank you for your information – I have definitely picked up something new from right here. I did however expertise a few technical points using this web site, as I experienced to reload the web site a lot of times previous to I could get it to load properly. I had been wondering if your web host is OK? Not that I am complaining, but sluggish loading instances times will very frequently affect your placement in google and could damage your high-quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my e-mail and can look out for much more of your respective fascinating content. Ensure that you update this again soon..

  16. sling tv

    Hi there, just became alert to your blog through Google, and found that
    it’s truly informative. I’m gonna watch out for brussels.
    I will appreciate if you continue this in future.
    Numerous people will be benefited from your writing.
    Cheers!

  17. asksylphoflight.tumblr.com

    hello there and thank you for your information –
    I have certainly picked up anything new from right here.

    I did however expertise some technical points using this web site, since I experienced to reload the web site a lot of times previous to I could get it to load properly.
    I had been wondering if your web host is
    OK? Not that I am complaining, but slow loading instances times will often affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords.
    Well I am adding this RSS to my email and can look out for a lot more of your respective exciting content.
    Ensure that you update this again soon.

  18. coconut oil

    Attractive element of content. I just stumbled upon your site and in accession capital to claim that I get
    in fact loved account your blog posts. Any way I’ll be
    subscribing for your augment and even I success you access constantly rapidly.

  19. ps4 games

    Howdy, I do think your website might be having internet browser compatibility issues.
    Whenever I take a look at your blog in Safari, it looks fine however,
    when opening in IE, it has some overlapping issues. I just wanted to
    provide you with a quick heads up! Apart from that, excellent blog!

  20. quest bars cheap coupon twitter

    I do believe all of the ideas you have offered
    on your post. They’re really convincing and can certainly work.
    Nonetheless, the posts are too quick for newbies.
    May you please lengthen them a little from subsequent time?
    Thanks for the post.

  21. quest bars cheap

    I am no longer certain the place you’re getting your information, however good topic.

    I needs to spend some time studying much more or working out more.
    Thank you for excellent information I was looking for this information for my mission.

  22. quest bars cheap

    Can I simply say what a relief to discover an individual who truly knows
    what they are talking about on the web. You certainly know how to bring a
    problem to light and make it important. A lot more people really need to check
    this out and understand this side of your story.
    I can’t believe you’re not more popular given that you surely have the gift.

Comments are closed.