Today, in Episode #1387, Bill H. asks, "How do I change a datetime field from midnight to 6PM?" Excel stores time values as a Fractional portion of a day [where a day is = to 1], so MrExcel shows us how to change our time values using Paste Special.