When you enter a number into an Excel cell that looks like a date, such as "Jun-1" or "6/1," Excel automatically adjusts the format of the cell to display a date, so you may not know that Excel ...
When you're setting up a Microsoft Excel spreadsheet that contains date information, you'll speed your task if you let Excel do the tedious work of filling in columns of individual date entries.
Create a Formula for Entering a Series of Incremental Times in Excel Your email has been sent To generate a series of incremental time values, you must first know how to use Excel's TIME() function.