Re: Excel - "cas x cislo"

From: MilanK <milan (zavinac)>
Date: 05. 08. 2005, 17:07 CEST
> Nevim, jak prevest ten cas 11:15 na cislo 11,25.

Co je to 11:25? Minuty + sekundy? Hodiny + minuty?

Za predpokladu ze mas 11:25 v bunke A1...

Ak minuty + sekundy:
=CONCATENATE(MINUTE(A1);",";SECOND(A1)/60*100)

Ak hodiny + minuty:
=CONCATENATE(HOUR(A1);",";MINUTE(A1)/60*100)

MilanK 
Received on Fri, 5 Aug 2005 17:07:10 +0200

This archive was generated by hypermail 2.1.8 : 05. 08. 2005, 17:07 CEST