Hi All,

Hope you can help me out, I am looking for a formula to take a time against a name and mark it on a separate worksheet for that person and calculate a fee chargeable for the time spent in a pre school.

i.e. Grace Adams 09:00 - 15:00 Julie Smith 09:00 - 12:00 (Sheet 1) (Sheet 2) Grace Adams 09:00 - 15:00 £10 (Sheet3) Julie Smith 09:00 - 15:00 £5.00

Hope that make sense.

Adam.