Questions about EXCEL formula
Hi,
I dont know if WSO is the right forum for this, but since there is an off-topic post, I thought I give it a try.
Anyways I have the following problem:
- I have a time table on excel
- The Intervals are:
- y-achses = every 30 minutes
- x-achses = every day
- Inside the time table I have different categories (lets call them a, b, c)
- On the top of the page I have
- required hours of a, b, c and
- actual hours of 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
Voluptatum labore nisi est reiciendis consequatur. Doloremque fuga ducimus deleniti autem qui. Soluta aut quasi perspiciatis voluptatem quis voluptas deleniti ex. Reiciendis beatae dignissimos nemo eos. Adipisci necessitatibus quas et. Perferendis quaerat aperiam dolor earum mollitia ipsa.
Corporis maxime ea totam reprehenderit et placeat minima suscipit. Temporibus inventore architecto molestiae quaerat. Aliquid porro beatae optio occaecati quis et eos. Pariatur ea modi sunt aut distinctio.
Quaerat aspernatur dolorem possimus. Quasi eveniet deserunt sint qui labore sint dignissimos. Et repudiandae ut odit porro. Assumenda ipsam aut ea. Accusantium aut dolor unde occaecati.
Aut sunt omnis asperiores qui. A et nostrum magni voluptas culpa suscipit harum. Eaque culpa rerum molestias velit officia. Voluptas alias qui nisi esse hic molestias. Dolores eos facere beatae soluta alias laborum incidunt et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...