Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with numbers and Time
OK, I fixed the issue by dropping the UDF and placing some side
formulas using some of the concepts in TimeDiff UDF. I added columns off to the side that calculate each row's Qty*Speed/ 60, Calculated time different by min then adding the hours to the minutes, and finally a column to get the difference between the Result (Qty*Speed/60) - Result(FinishTime-StartTime). I would like to figure out why the UDF would cause the CLEAR CONTENTS to stop when the UDF was in the Conditional Formatting. Any ideas would be greatly appreciated. Thank you again for helping me out Mr. Molloy. I can't thank people like you enough. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time issue | Excel Programming | |||
Time issue with Day Format | Excel Discussion (Misc queries) | |||
odd sort issue with numbers | Excel Programming | |||
Less than numbers issue please help | Excel Programming | |||
Run Time Issue | Excel Programming |