Adding up times

[Dal1980]

It seems that to add times I just need to use =SUM but I'm not getting the desired results. I've even made sure my data type for the cells I'm working with are time format h:mm

	A	B	C	D	E	F	G	H
1	M	T	W	T	F	S	S	Totals
2	8:30	8:00	8:30	8:00	8:30	0:00	0:00	17:30
								=SUM(A2:G2) should be 41:30

Can anyone point out where I've gone wrong please

Thanks

 

[Toadstool]

Hi Dal1980,

Try Custom Format [h]:mm

Book1
	A	B	C	D	E	F	G	H
1	M	T	W	T	F	S	S	Totals
2	8:30	8:00	8:30	8:00	8:30	0:00	0:00	41:30
Sheet2

Cell Formulas
Range	Formula
H2	H2	=SUM(A2:G2)

 

[Dal1980]

That's it, I had applied probably the correct formatting on the fields that held the data I wanted to add together but your comment helped me see that I needed to apply it onto the field that had the SUM formula. Once I used your suggested formatting on that field it switched over to showing the correct value.

Note to self: assume nothing, excel assumed nothing when it added all of theses data types together, who would have thought that the cell that received the value would be of the same data type lol


Thank you very much, you saved my mind as I spent ages trying to get this to show properly

 

[Toadstool]

...Thank you very much, you saved my mind as I spent ages trying to get this to show properly

You're welcome!
...and don't worry, Excel has many more tricks up its sleeve to send you over the edge to insanity.

 

[Dal1980]

Lol