Hi All

I am trying to sort a formula in a time sheet.

I have got two formula's but can not nest them for some reason.

=IF(P33="AL","07:30") - This however isn't returning 07:30 as number format.

-IF(P33=""","",SUM(P35-N35)-""00:30")

Day Date In Out Worked
Saturday 13/04/13 07:00 15:00 7:30
Sunday 14/04/13 AL AL 7:30

Thanks for looking