Creating a 'over time 'column

[BENTEGZ]

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

[Fotis1991]

Welcome to the forum.

In E2 and copy down

Please Login or Register  to view this content.

[BENTEGZ]

Thanks alot!

[Fotis1991]

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.