Ever wonder where that pesky 0.38 days comes from that you find when comparing dates that look to be the same?
In a recent inquiry, a reader wanted to know, “Why does a ‘one working day’ task show up as 0.38 calendar days?”
In his schedule he was using this formula in a Text1 field:
I tried a few formulas and different fields to see if this behavior was field-related, with no satisfactory answer. So I reached out to my guru, Barbecana Chief Operating Officer, John Owen! Well, he figured out where the 0.38 comes from.
Microsoft Project uses a numeric representation of Start and Finish dates, and it’s actually a decimal fraction of a day.
Given a start date of:
10/28/16 8:00 AM
and a finish date of:
10/28/16 5:00 PM
Microsoft Project converts that to 42671.33 for Start and 42671.71 for Finish.
The .33 at the end of start number is 0.33 of 24 hours, which equals 08:00.
The .71 at the end of finish number is 0.71 of 24 hours, which equals 17:00.
0.71 – 0.33 = 0.38