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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Summation of cells with a hh:mm:ss format
0
Discussion
Its easier to help if you attach a sample workbook to your post.
don (rep: 1989) Mar 31, '17 at 12:38 am
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.
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: 1989) 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