Question description:
This user has given permission to use the problem statement for this
blog.
Hello, I need help with conditional formatting. My issue: I have a delivery schedule that I need to track. If the order is created between 00:41 and 01:40, delivery time must be by 02:55. If the order time is between 01:41 and 02:40, delivery time must be by 03:55, and so on throughout the day 24hr. I need help creating a format that will highlight anything delivered past its scheduled time . Thanks.
Solved by B. J. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/04/2018 - 06:29
Hi
Excelchat Expert
05/04/2018 - 06:29
Welcome to Got it Pro
User
05/04/2018 - 06:29
Hello
Excelchat Expert
05/04/2018 - 06:30
Can you please share your excel sheet
User
05/04/2018 - 06:31
This is the end result, but I can have 75 to 100 lines to search through to get this result
Excelchat Expert
05/04/2018 - 06:31
Which column you would like to compare.
User
05/04/2018 - 06:32
B to E
Excelchat Expert
05/04/2018 - 06:32
can you please explain your requirement
Excelchat Expert
05/04/2018 - 06:33
For example row number 5 : 16:23 is creation time and your deliver time should 17 :55 but it delivered at 18:42 so its wrong
User
05/04/2018 - 06:33
If an order is created by the :40 of an hour it must be delivered by the :55 of the next hour
Excelchat Expert
05/04/2018 - 06:34
ok
User
05/04/2018 - 06:34
so if the order is created between 00:41 and 01:40, it must be delivered by 02:55
Excelchat Expert
05/04/2018 - 06:34
ok.
Excelchat Expert
05/04/2018 - 06:36
I will work and get back to you
Excelchat Expert
05/04/2018 - 06:36
Just give me 5minuts
User
05/04/2018 - 06:36
Thank you
Excelchat Expert
05/04/2018 - 06:40
if it is less than 40 minutes
Excelchat Expert
05/04/2018 - 06:40
for example first ticket received 4:28 is what will be the due time
User
05/04/2018 - 06:40
05:55
Excelchat Expert
05/04/2018 - 06:41
> 40 minutes correct
Excelchat Expert
05/04/2018 - 06:41
12:40 to 1:40 should be delivered at 2:55
Excelchat Expert
05/04/2018 - 06:41
ok. I got it.
User
05/04/2018 - 06:41
12:41 to 01:40 =02:55
Excelchat Expert
05/04/2018 - 06:42
ok
Excelchat Expert
05/04/2018 - 06:42
3:41 to 4:40 = 5:55
User
05/04/2018 - 06:42
Correct
Excelchat Expert
05/04/2018 - 06:43
5:41 to 6:40 = 7:55?
User
05/04/2018 - 06:43
Correct
Excelchat Expert
05/04/2018 - 06:43
ok got it
User
05/04/2018 - 06:44
We are 24/7, so it never stops
Excelchat Expert
05/04/2018 - 06:46
ok. let me share the file
Excelchat Expert
05/04/2018 - 06:47
Check this
[Uploaded an Excel file]
Excelchat Expert
05/04/2018 - 06:48
Is it working?
Excelchat Expert
05/04/2018 - 06:51
Are you there?
Excelchat Expert
05/04/2018 - 06:52
???
User
05/04/2018 - 06:54
Sorry, It looks like it's working
Excelchat Expert
05/04/2018 - 06:54
Ok Super.
Excelchat Expert
05/04/2018 - 06:54
If you want download the screen file as well for your reference.
User
05/04/2018 - 06:54
Thank you very much for your help
Excelchat Expert
05/04/2018 - 06:54
Please provide your valuable feedback and remarks.
Excelchat Expert
05/04/2018 - 06:55
your always welcome :)
Excelchat Expert
05/04/2018 - 06:55
Please end the session to support other users.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.