工作进度跟踪表excel
If you're working on a project, you might need to keep track of time in Excel, so you can tell a client how much time you've spent on their project, and get paid for your work. Or, use the time data to see how much of your day is spent on productive tasks, and how much is spent Googling and tweeting.
如果您正在从事一个项目,则可能需要在Excel中跟踪时间,以便可以告诉客户您在他们的项目上花费了多少时间,并获得了报酬。 或者,使用时间数据来查看您一天中有多少时间用于生产性任务,以及谷歌搜索和推文投入了多少时间。
输入当前时间 (Enter the Current Time)
To calculate the time spent on a task, you'll need to have a start time and an end time.
要计算在任务上花费的时间,您需要有一个开始时间和一个结束时间。
To quickly enter the current time in Excel, use the keyboard shortcut: Ctrl + Shift + ;
要在Excel中快速输入当前时间,请使用键盘快捷键: Ctrl + Shift +;
- When you start a task, use the shortcut to enter the start time in one cell. 启动任务时,请使用快捷方式在一个单元格中输入开始时间。
- When you finish working on a task, use the shortcut in an adjacent cell, to enter the end time. 完成任务后,请使用相邻单元格中的快捷方式输入结束时间。
In the screen shot below, the Task start times are entered in column B and the end times are entered in column C.
在下面的屏幕快照中,任务开始时间在B列中输入,结束时间在C列中输入。