To add up hours, use the formula =time column+duration values column and divide it by 24 to convert the answer to the desired unit, which is hours. To calculate minutes, use the formula =time column+ duration values column/(24*60) and divide the result by (24*60).