"That will assign 08:00 to Early rather than DAY" (emphasis added).

When I tried it 08:00 was assigned to Day. Although 08:00 = 0.33333 that
doesn't affect Excel's binary-based calculation, surely?

"Rick Rothstein (MVP - VB)" wrote:

That will assign 08:00 to Early rather than Late (see my follow up
posting).

That should have said...

"That will assign 08:00 to Early rather than DAY" (emphasis added).

Rick