multiply hours & mins by money

T

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

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
[email protected]

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/
 
Top