Hello,

I have just properly started using excel and I am trying to create a basic hours sheet that will work out how much over time i have worked. I think I am nearly there but i just have one problem.

The trouble I am having is with the over time column. I want it to automatically record how many hours i do over 8 hours in a day.

So if the 'Time In' (B2) is 8:00am and 'Time Out' (C2) is 4:05pm the 'Hours' (D2) column sets to 08:05, which is all good and i have managed to do.

I then want the 'Over Time' (E2) column to set to 00.05, as i would have worked 5 mins over time.

I am sure this is going to turn out to be a simple formula but any help for this novice would be much appreciated!

HOURS 2.xlsx

I have attatched a file with where i have got so far