excel spreadsheet that totals employee hours for the week

Hi,
Format the date cells as "mm/dd/yyyy hh:mm" then
A1: 05/05/2013 18:00
A2: 05/06/2013 02:00 B2: =(A2-A1)*24 (answer = 8)

Normek