Design your own to-do list - Formulas In Excel - Microsoft Excel Tutorials

9.  Design your own to-do list

Generate your own to-do list by entering the hours of the day in column A and your daily tasks in column B.

To generate your own to-to list:

1. Select cell B1 and type =TODAY().
2. Select cell A3 and type 7:00.
3. Select cell A4 and type the following formula: =A3+(1/24).
4. Select cells A4:A14.
5. From the Edit menu, select Fill and Down.

Note: To get increments of half an hour, use the formula =A3+(1/48). To display column A as shown in Figure 1-9, select Cells from the Format menu, click the Number tab, select Time from the Category list, select 1:30 PM, and click OK.

Watch the Video Tutorial - https://www.youtube.com/watch?v=RRC7jJLEHXA

 

Hope You Like This Tutorial - Give Comments