I do not have a start and end date. I have calculated the amount of time
each activity has taken. I now have a range of cells that each hold an
amount of time (3:12 - 3 hr, 12 min). I would like to total the range and
have it show me the total amount of time worked formated in
months:days:hours:minutes. I hope this helps explain the problem better.


"Big Tony" wrote:

I am required to maintain a log of the amount if time I work on different
projects. At the end of a month (and YTD) I need to calculate the total
number of month, days, hours and minutes I have spent on each project. I
have been using the SUM function, which works fine. But, I cannot figure out
the proper formating for the cell to have it display
months:days:hours:minutes. Has anyone solved this problem?

Thank you for your help.