Forum Discussion
Solved
Time values
I want to add a column of times (h:mm values) not dates or daily times, and then work with these values to calculate average duration of hours spent on various tasks. I have tried using the TIME fun...
Craftybilda In B41, you see 02:45, being 2 hours and 45 minutes. But dates and times in Excel are in fact numbers (a full day is being 1, and for instance 12 hours equals 0.5 etc.) In this particular case, the underlying value is 0.114583333333333. Your formula in B42 creates a time value of 0 hours, 0 minutes (the leftmost number) and 33 seconds (the two rightmost numbers). What exactly do you want to show in B42 and B43? In case you want to "transform" 02:45 to decimal hours (i.e. 2.75), you can multiply the B42 by 24 and format the cell as a number.
I could not understand what you want.
I mean, your calculated value is showing there the total of hours. It means the amount of hours is already calculated. 02:45 on B41.
If you adjust the formula to =TIME(HOUR(B41),MINUTE(B41),SECOND(B41)) it will have the same result 02:45.
Ps.: Its not part of the problem, but you can also convert to decimals by multiplying to 24.
I mean, your calculated value is showing there the total of hours. It means the amount of hours is already calculated. 02:45 on B41.
If you adjust the formula to =TIME(HOUR(B41),MINUTE(B41),SECOND(B41)) it will have the same result 02:45.
Ps.: Its not part of the problem, but you can also convert to decimals by multiplying to 24.