View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How to change hours and minutes to calculate charges?

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

On Sep 21, 9:20 am, E. Lewis <E.
wrote:
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