View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kilomike1 kilomike1 is offline
external usenet poster
 
Posts: 1
Default Excel Formula for adding training times.

Does anyone know of a formula to add cells with training times in a
hour+minute format? Example: Cell C1 is 1+12 (1 hour and 12 minutes traning)
and cell C2 is 0+55 (55 minutes of training) equals cell C3 3+07 (3 hours and
7 minutes total training (i.e.: 1+12 and 0+55 = 3+07).