Today I Learned . . .
If you represent time of the day as a negative decimal number between 0 - 1, and convert the cell to a time display, Excel will represent the negative decimal as a time subtracted from midnight.
(for example: -0.0347 = 11:10 PM)
No comments:
Post a Comment