Total Days, Hours, Mins addition

[Myxo]

Hi, i would like to know the formula to how to add Total Days, Hours and Mins... i have a sheet

Its Like this

D___H____M
0___22___50
1___10___25
1___16___55
X___XX___XX

I would like to get the total (X) Values... i mean total how many days, hours and mins... please if anyone knows... help me... thanks in advance.

 

[schielrn]

What is your expected results here? Are you expecting 4 days, 2 hours and 10 minutes?

 

[schielrn]

If what I stated previously is correct, this should work:

Excel Workbook
	A	B	C
1	0	22	50
2	1	10	25
3	1	16	55
4	4	2	10
Sheet1

Cell Formulas
Range	Formula
A4	=SUM(A1:A3)+(SUM(B1:B3)+(SUM(C1:C3)-C4)/60-B4)/24
B4	=MOD(SUM(B1:B3)+(SUM(C1:C3)-C4)/60,24)
C4	=MOD(SUM(C1:C3),60)

Hope that helps.

 

[Myxo]

It worked... Thanks alot.