Sum of Hours and Minutes to dd hh mm

[ozbeachbum]

Hi,
Cells are formatted [hh]:mm
W19 has 03:25
W20 has 26:14
W21 has 10:50

I am endeavouring to calculate the number of dd:hh:mm from the total of the 3 cells.

I tried the following to no avail, if some one could show me where I am going wrong I would appreciate it.
=INT(SUM(W19:W21)),HOUR(MOD(SUM(W19:W21,1)),MINUTE(MOD(SUM(W19:W21,1))

 

[etaf]

you could just format the cell
DD:HH:MM
and simply sum the Hours

OR concatenate the cells
=INT(B3)&":"&HOUR(B3)&":"&MINUTE(B3)
for a TEXT result

what are you planning ion doing with the result - just for a display - or want to use in a calculation

not sure how XL2BB will show

B3 is formatted
C3 is calc

Book7
	A	B	C
1
2
3		01:09:12	1:9:12
Sheet1

Cell Formulas
Range	Formula
C3	C3	=INT(B3)&":"&HOUR(B3)&":"&MINUTE(B3)

i just entered 1.38333333333333
in general to see what happens

 

[ozbeachbum]

Thanks,
I had formatted the target cell dd:[hh]:mm and was getting an incorrect answer.
Needed to remove the [ ]. Once done it works fine.
Thanks again.

 

[etaf]

you are welcome