View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Converting hours into minutes

Hi,

=A1+B1 would add the 2 times

Format the cell [hh]:mm

Mike

"Alison" wrote:

I have 2 colums, one in hours and one in minutes, i have converted the
minutes into hours and minutes how do i add the hours with the converted
hours and minutes?