Computing Hours/Minutes Times Hourly Rate

[PWFE]

Is there a formula to compute hours/minutes times an hourly rate to
determine an amount earned in Microsoft Office 2004 Excel?

 

[Peo Sjoblom]

Yes

start time in A1 end time in B1

=(B1-A1)*24*Rate

if you can start before midnight and end after midnight

=MOD(B1-A1,1)*24*Rate

so if you insert time in a format excel recognizes like hh:mm
then you can do all numeric calculations
For instance, for a week worked you might have

=B1-A1 in C1

=B2-A2 in C2

and so one for 5 days

then to get the total

=SUM(C1:C5)*24*Rate

will give you the total pay for a week
Note that you have to format result as general or currency or else
you will get a weird time value

--


Regards,

Peo Sjoblom