We talked about Article 19 – How to Check if a cell contains a date. Now, in this article, I will talk about checking the cell for time.
The way Excel stores dates as numbers, in the same way it stores time as numbers only. Only change is in range. The numbers get stored between 0 to 1. Hence, 6 AM is stored as .25, 12 PM is stored as 0.5 and so on.