Help! I am stuck calculating Days, Hours, Mins please help

[OB1]

Hi All and thanks for reading my post.

I am working on a spreadsheet typically for a game called Eve.

It is a skills spreadsheet that tells me the number of days hour
minutes required to learn a particular skill.

Basically i input the current level of skill and the goal level and ou
pops.......eg.

Days Hours Mins
23 15 39

Now i want to develop my sheet further and want a totals row at th
bottom to calculate the total time for a group of skills. I can get th
total number of days hours mins on a row but of course i invariably ge
this..........eg.

Skills to be done

Skill Days Hours Mins
A 5 13 49
B 16 20 11
C 1 16 59
D 0 43 36

Total 22 92 155

But i want to portray the days, hours and mins properly t
get............

From above example.

Days Hours Mins

Total 25 22 35 (I believe this t
be correct)

I hope there is someone out there that can shed some light onto thi
topic for me. I have trawled through the functions in excel, and jus
getting more and more confused.

Thanks for reading this lengthy post, and thanks in advance to anybod
that can help.

Best Regards

OB

 

[Alex Delamain]

Try this for size:

If your data is in a1:d5 (row 1 headings, column a is skills)

total for minutes (d6) is =MOD(SUM(D25),60)

total hours (c6) is =MOD(SUM(C2:C5)+QUOTIENT(SUM(D25),60),24)

total days (b6) is =SUM(B2:B5)+QUOTIENT(SUM(C2:C5),24

 

[N Harkawat]

On the cell where you need the final output
=(C5+INT(D5/24))&" days "&MOD(D5,24)+(INT(E5/60))&" Hrs "&MOD(E5,60)&" Mins
"
where C5 house days D5 hours and E5 minutes

 

[N Harkawat]

Ignore previous post as it ignores cases where hours are say 4000 and
minutes sum up to say 6000
This takes care of tose situaions
=(C5+INT((D5*60+E5)/1440))&" Days "&INT(MOD(D5*60+E5,1440)/60)&" Hrs
"&MOD(MOD(E5,1440),60)&" Mins"
where C5 house days D5 hours and E5 minutes

On the cell where you need the final output
=(C5+INT(D5/24))&" days "&MOD(D5,24)+(INT(E5/60))&" Hrs "&MOD(E5,60)&" Mins
"
where C5 house days D5 hours and E5 minutes