Hi,

Excel treats dates and times (essentially the same thing) as the

number of days from 1 Jan 1900 (ignoring some legacy issues).

When you enter a time, it converts that to the portion of a day. In

your case, 6 hrs = 0.25 of a day, so the actual *value* in the cell is

0.25 formatted as a time so display as 6:00hrs (say).

If you then multiply that cell by 65 you get 16.25.

Your problem then is really one of units. You are multiplying days by

an hourly rate. To fix, you have to convert them to be consistent:

Either convert the days to hours then multiply by an hourly rate:

(B25*24)*B26

Or convert the hourly rate to a daily rate, and apply that to the

days:

B25*(B26*24)

Same answer of course.

Read the excel help on date / time functions and it should all become

crystal clear!

HTH,

Alan.

--

Alan.

The views expressed are my own, and not those of my employer or anyone

else associated with me.

My current valid email address is:

http://www.velocityreviews.com/forums/(E-Mail Removed)
This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,

it MAY still be valid, but may also have been

deactivated due to spam. If so, and you want

to contact me by email, try searching for a

more recent post by me to find my current

email address.

The following is a (probably!) totally unique

and meaningless string of characters that you

can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb

"Crash" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...

> Greetings,

>

> 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?

>

> TIA,

> Crash.