首页 > 编程知识 正文

excel排班表怎么制作 分别排周末和工作日,excel函数自动排班表 星期

时间:2023-05-04 03:10:44 阅读:238921 作者:3575

excel自动排班有假期

Mock me if you will, but I use Excel to plan the timing for our holiday dinners. Monday was our Canadian Thanksgiving, so it was the perfect occasion to dig the planner out again.

如果可以的话,请嘲笑我,但是我使用Excel来计划我们的节日晚宴的时间。 星期一是我们的加拿大感恩节,所以这是再次挖掘计划者的绝佳时机。

You know that it's a delicate juggling act, trying to get everything cooked and on the table at the same time. Then, halfway through dinner you realize that the dinner rolls are still in the oven. Oops!

您知道这是一种微妙的杂耍动作,试图同时煮好所有东西并放在桌子上。 然后,在晚餐进行到一半时,您会发现晚餐卷仍在烤箱中。 糟糕!

To prevent the senseless loss of dinner rolls, and help things go smoothly, I use my Excel Holiday Dinner Planner.

为避免不必要的晚餐卷丢失和使事情顺利进行,我使用了Excel假期晚餐计划器。

Yes, it takes a few minutes to set up, by entering all the dinner items, and the preparation steps, but it's time well invested!

是的,输入所有晚餐项目和准备步骤需要花费几分钟的时间进行设置,但是花了很多时间!

If you're like me, and don't vary the holiday menu too much, you can reuse the worksheet, for every holiday.

如果您像我一样,并且不必过多调整假期菜单,则可以在每个假期重复使用工作表。

计算开始时间 (Calculate the Start Time)

Once the sheet is set up, you simply select the time that you want to serve dinner, and the Excel dinner planner calculates the preparation start time.

设置工作表后,您只需选择要提供晚餐的时间,Excel晚餐计划者就会计算准备开始时间。

跟随清单 (Follow the List)

With the planner, you'll have a complete list of dinner items, with preparation start and end times. Follow the list, and you won't be likely to forget those dinner rolls in the oven.

使用计划器,您将获得晚餐项目的完整列表,以及准备工作的开始和结束时间。 按照清单进行操作,您将不会忘记烤箱中的那些晚餐卷。

You can find more instructions, and download links, on the Excel Holiday Dinner Planner page on the Contextures website. _________

您可以在Contextures网站上的Excel Holiday Dinner Planner页面上找到更多说明并下载链接。 _________

翻译自: https://contexturesblog.com/archives/2011/10/12/plan-your-holiday-dinner-in-excel/

excel自动排班有假期

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。