In other words, as we approach midnight, the value of time approaches 1.
Formatting time
Time is displayed in Excel using a number format for time.
More on custom number formatshere.
For example, 0.5* 24 = 12 hours, 0.25* 24 = 6 hours, etc.
For more details, seeConvert Excel time to decimal value.
