![]() Auto Fill the rest of the column, either by clicking and dragging or double clicking on the auto fill handle. You can also select cells D2 and C2 as you are creating the formularather than typing the names of the cells.Ĥ. This is going to be a simple subtraction. Subtracting TimeĬolumn E, Total Time, is meant to calculate the time spent in each meeting. Let’s calculate the time spent in each meeting, and then we can move on to calculate a grand total. We are going to revisit this number format area again soon, so stay tuned. This means you are view time in a way most of us are familiar with: for example, 12:30 PM. If it doesn’t you can type it in manually, as it is listed below. The Type should display as h:mm AM/PM. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |