=C1*D1 (Time*Euro) - wrong ?!

[ReTeMa]

Hi,
i have data as follow in row 1

A1 ---> 09:00
B1 ---> 13:30
C1 ---> formula =B1-A1 with correct difference 04:30
all three column A, B and C are formatted as TIME properties hh:mm
D1 ---> 10,00 means 10,00 euro as fee per hour
E1 ---> formula =C1*D1 but i got 1,875 instead of 45,00

help me please

 

[SkipVought]

FYI: Why do Dates and Times seem to be so much trouble? faq68-5827

The take away that you need is that TIME units are DAYS. So multiply times 24 (Hrs per Day)

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[ReTeMa]

skip - thanks for your link, but i still don't now how to solve my calculation.
pls, could you write the exact formula?! :-D
tia

 

[SkipVought]

(your time value in days)*24

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[GlennUK]

That would be:

=C1*24*D1

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[ReTeMa]

thanks, problem solved