Tema: Re: excell date/time veikamas
Autorius: LB
Data: 2008-06-19 10:18:05
Stelmuze, aciu, veikia
LB
"Stelmuze" <stelmuze@gmail.com> wrote in message 
news:g3akkv$qce$1@trimpas.omnitel.net...
> gal tiks Time funkcija:
> =TIME(HOUR(A1);MINUTE(A1);SECOND(A1))
>
> "LB" <linasbal@ekoi.lt> wrote in message 
> news:g383cv$9i0$1@trimpas.omnitel.net...
>> yra A1
>>      2007.05.18 05:20
>>
>>
>> reikia i B1 tik 05:20
>>
>> A1 aisku date/time
>>
>> per date/time formatus galiu paslept dali, bet po to importavus i Accessa 
>> viestiek islenda. Reikia kad B1 butu tik 05:20 ir tekstas
>>
>> ar yr vaistu?
>>
>> LB
>>