1. In cell A1 press <Ctrl ;> to insert today's date – press <Enter> or <down_arrow>
2. In cell A2 press <Ctrl Shift ;> to insert the current time – press <Enter> or <down_arrow>
3. Press <Ctrl spacebar> to select column A then <Ctrl d> to fill the whole column with today’s date
4. Press <Ctrl z> to [Undo] the last command then <Ctrl 0> to hide column A
5. Press <Ctrl Shift 0> to unhide the column then repeat step 2 to get the new current time
6. In cell A4 press <Alt => to sum up the two times (needless to say you wouldn’t normally sum times!)
7. Now press <Ctrl `> (the key in the top left corner) to show exactly what’s stored in the cells
No comments:
Post a Comment