Formating Total Number of Days

[Big Tony]

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.

 

[David Biddulph]

There may be a cleaner way, but one option would be
=DATEDIF(0,A1,"m")&":"&DATEDIF(0,A1,"md")&":"&TEXT(A1,"hh:mm")
Unfortunately, just formatting as mm:dd:hh:mm doesn't work.

However, you might want to ask yourself the question as to how you are
separating months and days. If it has 32*24 hours, how many months and days
is that, and why?
Just days hours and minutes would be easier, and less ambiguous.

 

[GoBow777]

I am required to maintain a log of the amount if time I work o
different
projects. At the end of a month (and YTD) I need to calculate th
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 canno
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.

You can use a formula to show the desired format; where cell B2 is th
start date and cell C2 is the finish date or =NOW() function.


Code

 

[Big Tony]

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]

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.

 

[David Biddulph]

Didn't you see my reply on 5th June?

 

[Ron Rosenfeld]

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.

You give too little information.

How are you entering your times? Or are you calculating them? If so, how?

You want to see results including months. But a month can have 28, 29, 30 or
31 days. What rule do you want to use to decide how many days in your "month"?

--ron