RE: Nasobeni casu a cisla v Excelu

From: Likavcan, Alexander (Alexander.Likavcan@volkswagen.sk)
Date: 05. 02. 2002, 15:04 CET

Previous message: Likavcan, Alexander: "RE: Nasobeni casu a cisla v Excelu"
Maybe in reply to: Petr D: "Nasobeni casu a cisla v Excelu"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Zdar a silu Peter, dna 05.02.2002 si napisal(a):

> ak v poli A1 mas cas a v poli A2 cenu, potom celkova cena =
> HOUR(A1)*60*A2+MINUTE(A1)*A2+SECOND(A1)*(A2/60)
> musis ale nastavit bunku v ktorej ma byt vysledok na ciselny format
> 
tvoj vzorec je spravnejsi, no aj ked to Peter nepovedal myslel som, ze 
bude chciet cenu za kazdu zacatu minutu preto som tam dal roundup
takze moze si vybrat...

-- 
s pozdravom
AleXXX

Previous message: Likavcan, Alexander: "RE: Nasobeni casu a cisla v Excelu"
Maybe in reply to: Petr D: "Nasobeni casu a cisla v Excelu"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 05. 02. 2002, 15:04 CET