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.

Thanks,

John

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
VBA Code:
`=TEXT(D6-D7,"m+d+h+m") & " Months + Days + Hours + Minutes since extraction."`

Thanks,

John