Hi all,

A really stupid question that is probably easy has been bugging me for nearly an hour.

I have a pivot table that gives the totals in hours for student's work in a given period. There are some students that have done no work and some who have done 20 minutes. There are also some who have done 18 or even 35 hours

My pivot column shows figures such as this sample with the data starting in cell C5 and formatted as number so 1 hr 30 minutes is returned as 1.5:
0.28
0.00
18.00
0.00
0.00
0.00
0.00
0.00
38.00
0.00
17.45
6.28

I have decided to give points as follows:
If a student has done no work then the column should show 0
If a student has done over .05 hours they get 1 point per 0.5 hrs

My IF statement is working so far.

However if they have done more than 0 but less than 0.5 I still want to give them 1 point so for example the first student on my column above has done 0.28hrs so he/she will get 1 point. This is where my formula breaks down and where I need help!

Thanks in advance.

Simon