I have created a spreadsheet about hours worked and payment. I cannot figure out how to work out if someone clocks in at 8:30 and clocks out and 5:30 and is payed £10 an hour..what will the total be? how would i set this up on excel and work it out?

much thanks