Hi John,
To convert the decimal value of
0.2625 to hours and minutes, you can use the following formula:
Code:
=TEXT(TIME(0,ROUND(C2*60,0),0),"h:mm")
Here's how it works:
- ROUND(C2*60,0) multiplies the decimal value by 60 to convert it to minutes, and then rounds it to the nearest whole number.
- TIME(0,ROUND(C2*60,0),0) creates a time value using the rounded minutes.
- TEXT(TIME(0,ROUND(C2*60,0),0),"h:mm") formats the time value as "h:mm" (hours and minutes).
So in your example, if you enter the formula in cell D2, it should display
00:16.
I hope that helps!