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