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
|