Percentage Question
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
Answers
-
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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!