If you prefer for clarity, write the fraction as 12/24, 6/24 etc.
Add another variable
If hrs > 0.5 Then x = x+1 If hrs > 0.25 and hrs <=0.5 Then w = w+1
If you prefer for clarity, write the fraction as 12/24, 6/24 etc.
Add another variable
If hrs > 0.5 Then x = x+1 If hrs > 0.25 and hrs <=0.5 Then w = w+1
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote