Change a hours:minutes to a decimal or general number

[ttaylor1835]

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.

[#2]

@ttaylor1835 

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*duration

The catch is that the result is 36.8333.