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:

[Finish]-[Start]

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

Mystery solved!

Image Source