Macro gives the wrong date format
 

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
+-------------------------------------------------------------------

--
chin_un_le
-----------------------------------------------------------------------
chin_un_len's Profile: http://www.excelforum.com/member.php...fo&userid=3091
View this thread: http://www.excelforum.com/showthread.php?threadid=51642