For 2 cells with times, just add together like any number (=A1+A2+A3). To add 8 hours to the time in a cell, use this formula: =B2 + 8/24 NOTE: Use custom number format [h]:mm in the result cell to prevent rollover at 24 hours (see the screen shot in question "When I try to sum the time data..." below.)