How to add minutes in specific cell based on what i input

[Kenjiorson]

Cell E5 auto add minutes from cell D5 when cell C5 input either 1 or 2.
1 is auto add 45 minutes and 2 is 90 minutes, 1 formula is in cell E1 and 2 is in cell E2.
What formula/function to input in E5?
Thank you

 

[GuzmanServices]

Assuming if there's no value in Cell C5, Cells E5=D5. If so, try the following formula:

=IF($C5=1,$D5+$E$1,IF($C5=2,$D5+$E$2,$D5))

 

[Kenjiorson]

Assuming if there's no value in Cell C5, Cells E5=D5. If so, try the following formula:

=IF($C5=1,$D5+$E$1,IF($C5=2,$D5+$E$2,$D5))

Thank you !

 

[Kenjiorson]

Hi i had some problem with it

When i key 10am or 11am is ok

When i key in 10.30am or 10.35am, shows #VALUE!

Any solution to solve it?

 

[Kenjiorson]

Hi i had some problem with it

When i key 10am or 11am is ok

When i key in 10.30am or 10.35am, shows #VALUE!

Any solution to solve it?

Meaning If D5 i enter 10.25am or 10.30am, E5 will reflect #value!

only whole number than can
please advise thank you very much!

 

[GuzmanServices]

Hi, unfortunately Excel does not use decimals for time periods. Try entering it as 10:30, instead of 10.30.
Alternatively, you may enter .4375 - which Excel translates to 10:30 am.

 

[Kenjiorson]

Assuming if there's no value in Cell C5, Cells E5=D5. If so, try the following formula:

=IF($C5=1,$D5+$E$1,IF($C5=2,$D5+$E$2,$D5))

Hi if i want to add another 2 more eg
S1 and S2
S1 same as 1
S2 same as 2

how do i edit the formula or need write a new one?

 

[GuzmanServices]

Not sure what you meant above. Does S1 = 1 or E1?

 

[Kenjiorson]

Hi if i want to add another 2 more eg
S1 and S2
S1 same as 1
S2 same as 2

how do i edit the formula or need write a new one?

Cell E5 auto add minutes from cell D5 when cell C5 input either 1 or 2.
1 is auto add 45 minutes and 2 is 90 minutes, 1 formula is in cell E1 and 2 is in cell E2.
=IF($C5=1,$D5+$E$1,IF($C5=2,$D5+$E$2,$D5))

If i want to add in Cell C5, S1 is 45 minutes and S2 is 90 minutes.
how do i edit the formula or need write a new one?

If cell i4 read from cell C5,
1=120, 2=160, S1=100 and S2=130
How do i write this formula too

Thank you in advance

Not sure what you meant above. Does S1 = 1 or E1?

S1 is different from 1, it is a number i will manually input
meaning i will input either 1, 2, S1 or S2.
Thank you for reply

 

[Kenjiorson]

Hi if i want to add another 2 more eg
S1 and S2
S1 same as 1
S2 same as 2

how do i edit the formula or need write a new one?

sorry for my confusion
i mean S1 same as 1 is 60 minutes
S2 is 90 minutes