Macro gives the wrong date format

C

chin_un_len

Hello,

I have attached a macro with samples, this macro is calculating tim
between 2 dates and if a condition is met then colors the backgroun
RED, or a second condition if met colors the background Yellow.
What I really need is when the condition is met example 120 hours afte
the create date, to color background RED and give the date when the 12
hours occur, if create date is Feb 20 120 hour later it would be FE
24, right now it gives the time in decimal which really does not tel
me when it exceeded the time, the same for the yellow condition.
Now for the Medium and highs it should use only weekdays no weekends
for the TOPs it is 24/7 weekends included.

Thank you All in advance

+-------------------------------------------------------------------
|Filename: Open Report.zip
|Download: http://www.excelforum.com/attachment.php?postid=4396
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare 2 dates and give the date conditions are met 0
Conditional format of a control 2
Calculate time difference and convert 1
macro to color all text red in worksheet if within certain date 3
Conditional Format a cell in time increments 5
conditional format by comparing to current date 6
Excel Macro Help 1
Help with difference in time macro 6

Top