Quote Originally Posted by Bob Phillips View Post
You almost had it, but you could try

=(D7-C7)-((D7-C7)>=5)*0.5-((D7-C7)>=10)*0.5
Thank you but the problem is still there. I cant enter real time in the "work time" cell, (ex 7:15, 7:30, 7:45) now i have to enter (ex 7,25. 7,5. 7,75)

Tryed to use =MOD(C7-D7;1)*24 to get the time right but then the other calculation doesnt work.

I found this youtube link to help me but i don´t want the weekdays in it but perhaps some coding are helpfull.
http://www.youtube.com/watch?v=CtrFnGWqoGE