Percentage Question

Caroline Dunnell

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

Paul Newcome

You will first need to convert the time into a usable number then divide it by 24.

There are a number of solutions for converting hh:mm into a usable number in this thread below:

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time