Excel Sheet

[:Lively]

Bet you don't get requests like this too often, but if anyone has the time and wants to save me hours of learning microsoft excel, could someone please make me a sheet as follows:

Column 1 - Date - nothing too difficult, will just be entering the date in here
Column 2 - Start time - again, this will be filled in by me
Column 3 - End time - "
Column 4 - Pay rate - drop down box with two options, £8.07 and £10.09
Column 5 - Hours - end time take away start time and give this number in the form of the number of hours done, e.g. 4, 6.5
Column 6 - Pay - Column 5*4

Then a total box underneath totalling column 6

Also if the formulas automatically update when adding a new row that would be great,

Thanks

[Meanies]

I don't understand what you want in column 5

[Caution]

I don't understand what you want in column 5

He wants the amount of time worked, so if you worked 9 till 11 it'd show 2.

[:Lively]

ok i just want it to total the number of hours iv worked by taking finish time away from start time

[Meanies]

ah ok, the example bit confused me
I'll do it in a min

add [email protected] so i can send you it after

[:Lively]

ok tar, the examples were to ensure the number was given in general format so it will multiply by the pay rate properly, like half hour periods displaying as .5

[Meanies]

ooookay, starting it now

[Blob]

http://www.ryanclark.me/Times.xlsx

[Meanies]

guess im not needed then

[:Lively]

Blob that looked exactly what I needed, but there's a problem in that if you input something such as 14:00 till 20:30, it will put 6 in the hours box rather than 6.5?

So could u take another look at it please, tar