RE: Nasobeni casu a cisla v Excelu

• Previous message: Lasy: "MACROMEDIA FLASH - PRIRUCKA CI UCEBNICE"
• Maybe in reply to: Petr D: "Nasobeni casu a cisla v Excelu"
• Next in thread: Likavcan, Alexander: "RE: Nasobeni casu a cisla v Excelu"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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

> Mozna se zeptam hloupe, ale jak docilim tohoto:
> Pole A: Cas - Casovy udaj ve formatu hh:mm:ss
> Pole B: Cena za minutu - Cisleny udaj ve formatu 0,00 Kc
> Pole C: Celkova cena - Celkem Kc za dany cas
> 
> Kdyz totiz standardne zadam C=AxB, dostanu nesmysl, kterej pro priblizne
> spr
> avny vysledek musim (nevim proc) vynasobit jeste cislem 1440 plus nejaky
> dro
> bny...
> 
> Diky za rady.
> P.
> 
> 
zeby takto:
=HOUR(A1)*60+MINUTE(A1)+ROUNDUP(SECOND(A1)/100;0)
ked tuto bunku vynasobis jednotkovou cenou mas co si chcel.
ps: ak mas inak hovoriaci excel tak hledej smudlo :-)



-- 
s pozdravom
AleXXX

• Previous message: Lasy: "MACROMEDIA FLASH - PRIRUCKA CI UCEBNICE"
• Maybe in reply to: Petr D: "Nasobeni casu a cisla v Excelu"
• Next in thread: Likavcan, Alexander: "RE: 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:00 CET