Attendance and Fee Sheets based on times

[adamuk1]

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.

[JohnTopley]

Post a sample file (Not image) showing expected results.

To upload a file, click "Go Advanced" then scroll down to "Manage Attachments"