Forum Discussion
Change a hours:minutes to a decimal or general number
Hello, I am trying to find a way to convert hours that look like this (36:50) which is 36 hours and 30 minutes into a general number or decimal such as 36.5. Any help would be greatly appreciated.
IF the 36:50 is what it appears to be, an Excel datetime formatted as "[h]:mm", to convert from days to hours requires no more than the formula
= 24*durationThe catch is that the result is 36.8333.