有关Excel公式的问题
Hi,
我不知道是否WSO是正确的论坛,但是由于有一个较低的帖子,我想我尝试一下。
Anyways I have the following problem:
- 我有一个时间表
- 间隔是:
- Y-ACHSES =每30分钟一次
- X-ACHSES =每天
- Inside the time table I have different categories (lets call them a, b, c)
- 我有页面的顶部
- required hours of a, b, c and
- A,B,C的实际小时
Now what I want to do is, I want to make a formula that looks through the whole table and for every cell that has "a" in it, I want it to add 30min - and the final value of the cell shut be the sum of all the "a's" * 30 min
评论 (1)
Assumenda enim inventore molestias laboriosam eosnostrum. Ut similique non praesentium molestias.
See All Comments - 100% Free
WSOdepends on everyone being able to pitch in when they know something. Unlock with your email and get bonus:6财务建模课程免费($ 199的价值)
或者开锁有了您的社交帐户...