Thinking about changing how long I spend on a task into a percentage
Thinking about changing how long I spend on a task into a percentage
I have a list of numbers in an HH:mm format like 2:15, 3:00, or 1:45. To change 2:15 into a percent (which is about 2.25 hours), I used this formula. =hour(mod(F5,1)) + int(F5)*24 + minute(F5)/60 It works okay for times that aren't full hours like 1:0 or 2:0. But it fails when there are zeros in the time part, like 2:0 because the function gets confused. The error message says the MOD parameter needs numbers but F5 is text, so it can't be turned into a number. I need some help with this.
I'd make sure to work in minutes instead of hours, so I can just add them up. Like this: (Hour from cell F5 times sixty) plus the minute from cell F5. But what is that percentage talking about? If 100% means one hundred percent, how do we figure out which number goes there?
I think you are talking about Decimal time. There are a few ways to do it. My favorite for Excel is: =TEXT(A1*24,"0.00"). You can also wrap that in TIME or TIMEVALUE to turn it into parts of a day and use those kinds of things.