MS Excel ...总hrs工作公式 [英] MS Excel ...total hrs worked formula

问题描述

不是一个有着excel的大师，而是试着编写一个公式来计算正常星期一9a-5p周计划的总小时数。我已经想出了如何计算每日总数但是对于一周的总数我会假设我需要一个if声明。我不知道怎么写这个但是非常感谢一些帮助。

谢谢

展开 | 选择 | Wrap | 行号

解决方案

为什么不使用标准的Excel SUM（）函数，将前5个单元格相加？


Ronald

不是一个有excel的大师，而是试着编写一个公式来计算普通mon-fri工作的总小时数9a -5周的时间表。我已经想出了如何计算每日总数但是对于一周的总数我会假设我需要一个if声明。我不知道怎么写这个，但非常感谢一些帮助。

谢谢

我不认为你''我需要任何类型的if语句。查看您的数据，

展开 | 选择 | Wrap | 行号

不是一个有excel的大师，而是试着写一个公式来计算正常星期一9a-5p周工作时间的总工时。我已经想出了如何计算每日总数但是对于一周的总数我会假设我需要一个if声明。我不知道怎么写这个但是非常感谢一些帮助。

谢谢

展开 | 选择 | Wrap | 行号

Not that of a guru with excel but tryin to write a formula that will calculate total hrs worked for normal mon-fri 9a-5p week schedule. I have figured out how to calculate daily totals but for week total I would assume I need an "if" statement. I am not sure how to write this but would greatly appreciate some help.
thank you

Expand|Select|Wrap|Line Numbers

解决方案

Why don''t you use the standard Excel SUM() function, whereby you sum the previous 5 cells?

Ronald

Not that of a guru with excel but tryin to write a formula that will calculate total hrs worked for normal mon-fri 9a-5p week schedule. I have figured out how to calculate daily totals but for week total I would assume I need an "if" statement. I am not sure how to write this but would greatly appreciate some help.
thank you

I don''t think you''ll need any sort of if statement. Looking at your data,

Expand|Select|Wrap|Line Numbers

Not that of a guru with excel but tryin to write a formula that will calculate total hrs worked for normal mon-fri 9a-5p week schedule. I have figured out how to calculate daily totals but for week total I would assume I need an "if" statement. I am not sure how to write this but would greatly appreciate some help.
thank you

Expand|Select|Wrap|Line Numbers

这篇关于MS Excel ...总hrs工作公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！