Hello All,
I am new to this and hope you can help.
I have an Excel report I have to generate. I need "Call Back" (F3) to show highlighted in red if time value of (F3) is = to or greater than 4 hrs. of "Time Reported" (C3) and highlighted in green if value is before 4 hrs. Also "Arrival Time" (G3) needs to be highlighted green if within 24 hrs. of "Time Reported" (C3) and highlighted red if after 24 hrs. of "Time Reported" (C3).
Any help in this matter is greatly appreciated.
Thanks.
Jerry
This should be simple but, I have played around with different formulas but have not found one that works. =F3<TIME(0,240,0) worked some of the time but just not consistent.
Thanks in advance for everyone's help.
Enter all times with dates seeing that you will have periods exceeding 24 hours in a format like this
15-7-2013 9:15 AM unless you have another way of determining what day the times indicated belong to.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank You so much worked just like I needed it to. then I was able to add the second condition to F3 for the green condition. Can you please explain what the "=4/24" does? I tried the same formula but did not have the /24 on the end and it did nothing.
Thanks again.
To Excel 1 day = 1, thus 1hr =1/24 thus 4 hrs = ....
That makes sense. Again thank you for you time.I added the final product for other users to see and get answers from.
Thanks Pepe for giving the explanation. You beat me to it.
Thanks Jerrygardner for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks