From koffice  Fri Jul 21 16:04:00 2006
From: Carsten Niehaus <cniehaus () gmx ! de>
Date: Fri, 21 Jul 2006 16:04:00 +0000
To: koffice
Subject: HOUR() for more than 24h
Message-Id: <200607211804.17918.cniehaus () gmx ! de>
X-MARC-Message: https://marc.info/?l=koffice&m=115350191030537
MIME-Version: 1
Content-Type: multipart/mixed; boundary="--===============1200261009=="

--===============1200261009==
Content-Type: multipart/signed;
  boundary="nextPart3587212.bRz0yahqS3";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart3587212.bRz0yahqS3
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi

In a spreadsheet of mine in cell e36 I have an amount of hours, for example=
=20
56:30 (56 hours and 30 minutes). Ok, now I want to multiply the hours by a=
=20
number (like the money you get per hour).
=3DHOUR(e36)*10 gives me 80 because HOUR(e36) returns 8. That even make sen=
se,=20
as HOUR() only returns modulo 24 (0..23) and 48h + 8h =3D 56h.

But as there is no DAY() function to work around this I have no clue how to=
 do=20
this.

Any pointers?

Please CC me in replies.
=2D-=20
Gru=DF,
  Carsten Niehaus

--nextPart3587212.bRz0yahqS3
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQBEwPsB29GaGyAowFcRAjPIAJ9kCa7e0RXgBuV6uklA9Xx1KLb8rACcCPsK
XXIpf8xuYJDBMrk+lRcTX1g=
=EmIE
-----END PGP SIGNATURE-----

--nextPart3587212.bRz0yahqS3--

--===============1200261009==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

____________________________________
koffice mailing list
koffice@kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice

--===============1200261009==--