Hi, I am sure this is simple, but everything I have tried isn't working.
I am working on a time allocation sheet and I need to work out how much of the day is allocated to a certain project:
"Daily Hours" Column - will always be 9:00 (hh:mm)
"Time Allocation" Column - our PM's will add into a column how much time allocated to that job - so for example - 2 hours - 2:00 (hh:mm)
I need it to work out a % of the day to come up, but everything I have tried isn't working and says "invalid Operations" - I know this should be 22.22% but I can't get it working.
Any help will be much appreciated, thanks
