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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!