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
Dolores eos nostrum debitis repellendus perspiciatis quia ea. Minus qui eveniet omnis sint. Sunt in voluptatem eveniet placeat laudantium soluta sunt.
Magnam et inventore saepe autem sunt pariatur necessitatibus. Quia natus et eos natus. Itaque et porro tempore nisi officiis excepturi.
Dolores et ipsam illum sunt illo animi occaecati sequi. Dolore animi est expedita nemo consequuntur ut aperiam iste.
Incidunt tempore veritatis quo. Dolorem nam natus voluptas. Unde ut et illo corrupti.
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...