On 2007-08-21, Crash <> wrote:
> On Tue, 21 Aug 2007 21:47:13 +1200, Lawrence D'Oliveiro
><_zealand> wrote:
>
>>In message <>, Crash wrote:
>>
>>> I am using Excel from Office 2003 with XP PRO. I cant get time #
>>> hourly rate to work. The formula is =B25*B26. B25 is 6:00 with the
>>> cell formatted as 'custom h:mm'. B26 is $65.00 formatted as 'Currency
>>> -$1234.10' with 2 decimals. The receiving cell is the same format as
>>> B26 and has the value of $16.25 (? - should be $390.00).
>>>
>>> Can anyone identify what is wrong here?
>>
>>What are the actual (i.e. not formatted) values in the cells?
>
> To the best of my knowledge those are the actual values - if there is
> a way of viewing 'unformatted' values then I don't know it.
time is measured (numerically) in days. (not hours, minutes, or seconds)
multiply by 24.
--
Bye.
Jasen
|
