Hey,
I am quite new to excel but need to use it for some work reports and rosters. I have read over 100 forums but still can’t find help for what I am looking to do.
I need a formula that will work out how many hours a staff member worked. I know that if I do the first formula in the document it works out the exact hours for me. But I need a formula that will work out if the answer is over 6 hours worked it will take 1 hour off but if it is under 6 hours it will show the amount of hours without taking any time off (this needs to all be done in the same cell some how). I could do it if I was able to use 4 cells but I can only use 3. After 3 or so hours I somehow came up with a complicated way to work out how to take an hour off if it is over 6 hours but if it is under 6 hours the cell stays blank. That is probably confusing so I have attached an example of what I have got and what I need to do.
If it is at all possible any help would be much appreciated.
Book1.xls
Bookmarks