How to change hours and minutes to calculate charges?

E

E. Lewis

I am trying to set up an excel worksheet to calculate and charge for time
spent by computer users.

Can anyone help me?

E. Lewis
 
P

Pete_UK

If you have a start time in A1 and a finish time in B1 (in Excel time
format), then the time difference (in C1) is:

=B1-A1

If you have an hourly rate in D1, then this is the charge (in E1):

=C1*D1*24

Format this cell as currency.

Hope this helps.

Pete
 
Top