You can use the time and date function in Excel to get to what you want.
Set up 5 columns headed as follows (or whatever you want to name them)
Start Time: End Time: Actual Time: Day Rate: Time Charge:
Enter in the first column you start time for example
09:55:00
Enter in the second column your end time for example
11:05:00
Enter in the third column the formula =(b2-a2) which means 11:05:00 less 09:55:00
This will give the answer 01:10:00
In the next calculation that answer is recognised as a fraction of a day.
So if your hourly charge was £50.00 enter in the next column £1200.00 which amounts to (24*£50)
In the next column enter the formula =(d2*c2) which means 01:10:00 times £1200
This will give you the answer £58.33
You need to format the cells in columns a, b, and c as "custom" and select from the options given "hh:mm:ss"
You need to format the cells in columns d and e as "currency"
Hope this gives you what you want.
Regards
G7SWZ