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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula for adding time eg. 13:45 + 22:15 + 10:45 + 19:30 (https://www.excelbanter.com/new-users-excel/151943-formula-adding-time-eg-13-45-22-15-10-45-19-30-a.html)

Denie

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

Formula for adding times eg. 17:45 from a selection of cells

Mike H

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

Simply add them:-

A1+A2+A3

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

Mike

"Denie" wrote:

Formula for adding times eg. 17:45 from a selection of cells

All times are GMT +1. The time now is 08:31 PM.