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]

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]Break[/td][td]

5​

[/td][td]

2​

[/td][td]16:30[/td][td]<-- "16:30"[/td][/tr]

[tr=bgcolor:#FFFFFF][td]No break[/td][td]

4​

[/td][td]

3​

[/td][td]

1.333333​

[/td][td][/td][/tr]
[/table]
=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