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
Bookmarks