Working on a spreadsheet for my new job at work. I have (actual hours) in row K and (spent hours) in row L. In row M I have a percentage but It is the reverse of what I need. Example I have 30 hours in row K. And 30 hours in L it shows this percentage as 0% but I need it to be 100% as the hours are all used up on the specific task. Test sheet below ( Made with numbers for Mac but exported into excel format) hopes this makes sense!! Thanks in advance.
Your description doesn't follow your example.
In J2 you show 32.27 hours, and in K2 you show 15.2 hours used. L2 should be =K2/J2 (47.1%) and M2 should be =J2-K2 (17.07)
In Excel, ranges described by letters (J, K, L) are columns, not rows.
Entia non sunt multiplicanda sine necessitate
As I am using numbers for the mac I think my columns might translate to be a different layout to yours.
I still cant figure this formula out. if i 50 in actual hours and then 2 in spent hours instead of seeing %96 I need to reverse so I can see it as %4.
=2/50 gives 4%
=spent hours/actual hours
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks