Overtime calculation

Hi I need formula for calculating overtime

Time In. Time out

Column A. Colum b. Column c. Column d

25/05/15. 14:45. 26/05/15 7:00

Total hours 16, 8 hours overtime how to calculate using formula please any know the formula

Assuming your data for Date In, Time In, Date Out and Time Out are in cells A1:D1 respectively:

Please Login or Register  to view this content.

Where 8 is the number of normal working hours (change to suit). This function is just adding the date and time together for In and Out, subtracting the In from the Out and multiplying to get hours instead of days. Then you just subtract your normal hours and you're left with the overtime