Time into formula

[silentwolf]

Hi guys,

can someone tell me how to I need to change this function so I can enter a Time wenn the Cell has a certain value.

=if("A1"="Break";16,5;B1/C1)

it is german so that is why the";" is writing not like the english version ","

But what I like to achieve is that in the cell gets writen 16:30 when the value in A1 ="Break" and if a other name then do a calculation.

Many thanks for your help.

tried like above but that does not work ..(

 

[sandy666]

maybe "16:30" instead of 16,5
or
TIME(16,30,0)

 

[silentwolf]

Hi,
no unfortunatelly that is not working either I did try that already ..(

 

[sandy666]

Break	5​	2​	16:30	<-- "16:30"
No break	4​	3​	1.333333​

=IF(A1="Break","16:30",B1/C1)

you can try: TIME(16,30,00)

 

[silentwolf]

Hi,
thanks-- I got it with your help!
=if(A1="Break";Time(16;30;0);B1+C1/60*24)
not sure in english but it works

 

[sandy666]

I'm glad if it works for you

Have a nice day

 

[silentwolf]

Thanks you too

 

[sandy666]

You can always use this service: Translator