如何根据总小时数计算天数？ [英] How do I calculate days based on total hours?

问题描述

Hello guys

根据我每天工作的总小时数和小时数，我在尝试计算工作天数方面遇到了一些问题。



例如，我每天工作8小时，在工作结束时，我有420小时。我如何计算我工作的天数？



我尝试了什么：



尝试将420除以8得到数字os天，然后将该值除以7得到周数。

解决方案

如果你每周工作7天，那你就是对的。我..不，我每周工作5天。



因此，如果单元格A2包含工作小时数，您可以使用公式

= A2 / 8

如果你想要整天只做那个

 = INT（A2 / 8）

要获得单元格C2中使用公式的周数使用公式

 = A2 / 8/5 

或者如果您想要整周使用

 = INT（ A2 / 8/5）

Hello guys
I'm having some problems trying to calculate the number of days worked, based on total hours and the hours I work per day.

For example, I work 8 hours a day, and at the end of my job's internship, I have 420 hours. How do I calculate the number of day's I've worked?

What I have tried:

Tried to divide 420 by 8 to get the number os days, and then divide that value with 7 to get the number of weeks.

解决方案

You are right in what you are doing IF you work 7 days a week. Me ..no, I work 5 days a week.

So if cell A2 contains the hours worked you can get the Days worked in cell B2 with the formula

=A2/8

If you want whole days only then make that

=INT(A2/8)

To get the number of weeks worked in cell C2 use formula

=A2/8/5

or if you want whole weeks only use

=INT(A2/8/5)

这篇关于如何根据总小时数计算天数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！