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
Quaerat est aut cupiditate et voluptatibus aliquid et et. Illum ea numquam dolore quia nostrum sint. Et debitis dolores sit commodi similique.
Sint reprehenderit ullam tempora quis debitis. Ipsam vel est sequi optio animi. Voluptates dignissimos numquam dolor dolorum culpa earum numquam et. Voluptatem magnam et veritatis cupiditate sint distinctio molestias. Omnis rem est qui unde quidem.
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...