Summation of cells with a hh:mm:ss format

0

Next question though..just doing a sum of two cells, however, the format of each cell is a 'Time hh:mm:ss' and the cells are not adding. One cell is taking a total from another worksheet in the workbook eg) ='AS'!L34

Answer
Discuss

Discussion

Its easier to help if you attach a sample workbook to your post.
don (rep: 1247) Mar 31, '17 at 12:38 am
Add to Discussion

Answers

0

You can just add them like regular cells and it will add the time together.

To get more specific, you need to include an example.

When I have two cells with that format and one says 10:30 and another 2:30 and sum them I get 13:00 which is what I would expect to get.

Discuss

Discussion

Found the resolution......
dee (rep: 2) Mar 31, '17 at 4:52 pm
We kindly ask that you post it here and select it as the Answer so future visitors can also solve this issue if they have it.
don (rep: 1247) Mar 31, '17 at 9:57 pm
Well it was a typical =SUM(B2+B3) formula, but the category was (Custom [h]:mm:ss) format, in the total cell and the B2 and B3 cell.
dee (rep: 2) Apr 1, '17 at 4:29 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login