Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 hours minutes required to learn a particular skill. Basically i input the current level of skill and the goal level and out pops.......eg. Days Hours Mins 23 15 39 Now i want to develop my sheet further and want a totals row at the bottom to calculate the total time for a group of skills. I can get the total number of days hours mins on a row but of course i invariably get 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 to get............ From above example. Days Hours Mins Total 25 22 35 (I believe this to be correct) I hope there is someone out there that can shed some light onto this topic for me. I have trawled through the functions in excel, and just getting more and more confused. Thanks for reading this lengthy post, and thanks in advance to anybody that can help. Best Regards OB1 -- OB1 ------------------------------------------------------------------------ OB1's Profile: http://www.excelforum.com/member.php...nfo&userid=461 View this thread: http://www.excelforum.com/showthread...hreadid=278319 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Problems calculating total hours | Excel Discussion (Misc queries) |