=TEXT(D1-D2,"d+h+m") not working over a month

[bowlesj]

Hi,

The formula in the subject line is giving the wrong number of days when the span of time is over a month.

My attached picture contains two snapshots.

• The first snapshot shows my highlighting the formula in the subject line so you can see it in the formula bar. Here the days is the extra days across a month (4 days rather than the number of actual days).
• The second snapshot shows where I copied the set of cells down and I changed the formula to include the month. This is the revised formula

  =TEXT(D6-D7,"m+d+h+m") & " Months + Days + Hours + Minutes since extraction."

  . Again I highlighted it so you can see it in the formula bar. Here the months is incorrect. It should be 1 month.

How might I get the actual total days? Once I have that I can figure out the weeks. Actually "W+D+H+M" would be best if that is possible. I tried "w+d+h+m" and that just showed "w+4+7+3".

Thanks,
John

 

[Peter_SSs]

Duplicate to: =TEXT(D1-D2,"d+h+m") not working if days is over 1 month?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread since the other has a response so please continue in the linked thread.