View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hadleigh
 
Posts: n/a
Default Adding columns of times

I'm trying to add increments of time (in the h:mm format, for example 3:15),
to come up with the total hours and minutes in part of a column, in Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and
neither works properly. I've tried adjusting the format of the cell with the
formula in it. Still not working. Can anyone help? Thanks.