Am 19.07.2011 16:29, Rich Shepard wrote:
The follow up question is how do I multiply the value of this cell by an hourly rate (cell format numeric) to calculate the amount owed? Calc gets upset trying to multiply a time (say 06:00) by a currency (say $20.00) to produce a total currency value of $120.00.
All dates and times in all spreadsheet programs are numbers in unit "Days". Today is day #40743. 40743.75 is the same value as 2011-07-19 18:00 =X1*24 returns the time number in cell X1 in unit "Hours". =X1*24*Y1 multiplies the hours with an hourly wage in Y1. Hope this helps. Andreas -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
