1

If this is a time you should enter it as: 01:00:00 and format it like: And then you will just use simple SUM(A1:A2):


Only top voted, non community-wiki answers of a minimum length are eligible