multiply hours & mins by money

[Terry]

I have set up the clock on & clock off times and the
difference, but I am unable to multiply the difference by
my hourly rate. How can I do this?

 

[Norman Harker]

Hi Terry!

Since times are recorded by Excel as a decimal part of 1 day:

=ElapsedTime*24*HourlyRate
Format General, Number, Accounting or Currency


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/