工作进度跟踪表excel_在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中快速输入当前时间,请使用键盘快捷键: