I have attached a spread sheet I need to have the times added up with monday to friday times, however in the hours column it can only show 45hrs, the OT/1 column must show the balance of the hours added with the Saturday time, then if the worker has worked his hours 45 + the 7 O/T1 then 60 must automaticlly appear on the bones column, attached is the spread sheet with the example if somebody could help with the formulas on office 2010

Thanks a million