Formula work on certain number only,

[Kenjiorson]

Will write down my formula here as i am not able to use the upload mini-sheet.

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.

Cell E1 - =Time(0,45,0)
Cell E2 - =Time(0,90,0)
Cell E5 - =IF($C5=1,$D5+$E$1,IF($C5=2,$D5+$E$2,$D5))
Thanks to GuzmanServices for the great help on cell E5 formula

It works on some cell like D7,
But D1 and D2 have issues

I tried out some number and it only work on whole number like,
eg 11pm, 3pm and 7pm.
If have hour and minutes, won't work. e.g 10.10am, 4.30pm and 7.05pm.

what formula should i edit or redo?

thanks in advance!

 

[DanteAmor]

I believe that a time is not correctly captured in cells D5 and D6, apparently, from what you have in your image, you have text instead of a time.


Try:

Libro1
	A	B	C	D	E	F
1				1	00:45:00
2				2	01:30:00
3
4
5			1	10:25 a. m.	11:10 a. m.
6			1	10:30 a. m.	11:15 a. m.
7			2	04:00 p. m.	05:30 p. m.
Hoja1

Cell Formulas
Range	Formula
E5:E7	E5	=IF($C5=1,$D5+$E$1,IF($C5=2,$D5+$E$2,$D5))

With pleasure.
Dante Amor

 

[Special-K99]

I agree with Dante.
Times are separated with a colon : not a full stop .
D5 and D6 is text.
D7 is also text, so E3 cannot contain that formula, it must also be text.

 

[Kenjiorson]

Thank you so much all, much appreciate