On 2007-08-21, Crash <(E-Mail Removed)> wrote:
> On Tue, 21 Aug 2007 21:47:13 +1200, Lawrence D'Oliveiro
><(E-Mail Removed)_zealand> wrote:
>>In message <(E-Mail Removed)>, 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.
On 2007-08-21, Alan <(E-Mail Removed)> wrote:
> Excel treats dates and times (essentially the same thing) as the
> number of days from 1 Jan 1900 (ignoring some legacy issues).
It's the number of days since 31 december 1899 (except before march 1900)