RE: Cas v Excelu

• Previous message: pavel@pilsen.cz: "Re: samo otvaranie okien v IE"
• Maybe in reply to: Pavel Trubl: "Cas v Excelu"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Zdar a silu Kamil, dna 28.08.2002 si napisal(a):

> > Ma v jedny bunce napr. cislo 3000, ktery vyjadruje pocet sekund.
> > Potrebuje, aby mu vedle v bunce vypadla hodnota v hodinach, minutach a 
> > sekundach. Ja excelu nepanimaju, proto se obracim na vas.
> 
> v excelu je funkce čas(hod, min, sec) ...
> 
> takze do vedlejsi bunky =čas(0,0,A1) se zvolenim
> spravneho formatu by mohlo pomoci..
> 
> 
tvoj postup funguje do hodnoty cisla 32767 ~ 9:06:07
ak bude pouzite vyssie cislo excel (w2k) zblbne :-((
trosku som to prepisal, urcite to ide aj lahsie :
"takze do vedlejsi bunky"
=ČAS(ZAOKROUHLIT(A2/3600;0);ZAOKROUHLIT((A2/3600-ZAOKROUHLIT(A2/3600;0))*60;
0);((A2/3600-ZAOKROUHLIT(A2/3600;0))*60-ZAOKROUHLIT((A2/3600-ZAOKROUHLIT(A2/
3600;0))*60;0))*60)


asi sa to zalomi ale funguje to az do poctu sekund 86399 ~ 23:59:59
potom to skoci na dalsi den ;-)

s pozdravom
AleXXX
-- 

Remember: there are no strangers in the world,
only friends who have not yet met.

• Previous message: pavel@pilsen.cz: "Re: samo otvaranie okien v IE"
• Maybe in reply to: Pavel Trubl: "Cas v Excelu"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 28. 08. 2002, 10:20 CEST