+ Reply to Thread
Results 1 to 2 of 2

If before 8am or after 18:00

  1. #1
    Registered User
    Join Date
    04-29-2021
    Location
    Cornwall,England
    MS-Off Ver
    MS office 2013
    Posts
    1

    If before 8am or after 18:00

    Hello,

    I am trying to make a formula that looks at a date and works out if it came in at a certain time to get a due date.

    IF the item comes in on 1 day between 08:00 and 18:00 the job has 8 days to complete.

    IF the item comes in between 18:00 the day before and 08:00 on that day they have 8 days up to 18:00 from that day to complete.

    I cant work out how to get the formula to work out the day before and add 8 days from the next day.

    05/04/2021 09:56:00 This one would have 8 days to complete up to 18:00 on the 13/04/21

    25/03/2021 02:00:00 this one would have 8 days to complete up to 18:00 on the 21/04/21

    25/03/2021 19:21:00 This one would have 8 days to complete up to 18:00 on the 22/04/21

    Thanks for the help.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: If before 8am or after 18:00

    Hi, welcome to the forum.
    Looks like everyone is working with times and dates these days.
    I suggest you attach a dummy sample file with what you have and what you would like to obtain, will make it easier than guessing your layout and thinking things up that do not apply.
    Google does wonders, one I found https://www.exceltactics.com/definit...s-times-excel/
    and there are more like these
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1