Tracking actual time in percentages, reporting in hours?
A component is adamant about tracking their actual time on projects based on percentage of an 8hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way for staff to enter a percentage and convert that to hours for reporting purposes?
Best Answer

Hi @LynneDavis,
You could use an additional column to do the conversion and report the number of hours. When one enters the percentage value, the new column (with a column formula) could multiply the % by 8 (hours in a workday).
Would look something like this:
=[Percentage Column Name]@row * 8
So if the percentage was 75, the result would be 6.
Just replace the text "Percentage Column Name" to the name of your own percentage column.
You could also hide the new column that displays the hours, but still include the column in you reports.
Answers

Hi @LynneDavis,
You could use an additional column to do the conversion and report the number of hours. When one enters the percentage value, the new column (with a column formula) could multiply the % by 8 (hours in a workday).
Would look something like this:
=[Percentage Column Name]@row * 8
So if the percentage was 75, the result would be 6.
Just replace the text "Percentage Column Name" to the name of your own percentage column.
You could also hide the new column that displays the hours, but still include the column in you reports.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!