[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    HOUR() for more than 24h
From:       Carsten Niehaus <cniehaus () gmx ! de>
Date:       2006-07-21 16:04:00
Message-ID: 200607211804.17918.cniehaus () gmx ! de
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


Hi

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

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

Any pointers?

Please CC me in replies.
-- 
Gruß,
  Carsten Niehaus

[Attachment #5 (application/pgp-signature)]

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


[prev in list] [next in list] [prev in thread] [next in thread]