Formula for adding time eg. 13:45 + 22:15 + 10:45 + 19:30

M

Mike H

Simply add them:-

A1+A2+A3

Ensure the cell with the addition formula in is formatted [hh]:mm

Mike
 
Top