Calculating working hours

[Mickmoi]

Hello!

I'm doing a excel sheet that keeps track on work what i have done.

So, Product, Location and Date are ok. I currently have Hours in 2 seperate cells, lets say A3 10 and B3 11. So it calculates that Total is 1 hour.

However, when it exceed over 1 hour for 1-30minutes, it needs to calculate total of 1,5 hours. And if it exceed over 1hour 30minutes, it should be 2 hours and so on.

Examples:

Product Location Date Hours Total
A B 3.3 10-11 1

Product Location Date Hours Total
A B 3.3 11-12.10 1,5

Product Location Date Hours Total
A B 3.3 13.10-14.20 1,5

Product Location Date Hours Total
A B 3.3 15-16.30 2

It may be a little bit confusing, but i hope that somebody will understand that.

Is it even possible?

Thanks!