Try
Insert into Table2 (FactoryID, AreaID, TotalTime(Mins)
Select FactoryID, AreaID, SUM(Time(Mins)) From Table1
Where FactoryID = '116' And AreaID = 'A1'
Group by FactoryID, AreaID
You have to give values for all fields in the insert (three fields in this case)