How do I display decimal hour as time? Example, I created a formula (originally in Exel) where the result is 2.25. I need this to be displayed as 2:15, (2h, 15m). Here is the formula in cell b8 =SUM((A6/18)*B3 (B6/8)*B3 (A6 B6)/70*B3 B2)/60

B1=DURATION(0,0,A1,0,0,0)

The DURATION function combines separate values for weeks, days, hours, minutes, seconds, and milliseconds and returns a duration value.

DURATION(weeks, days, hours, minutes, seconds, milliseconds)

Hold on a minute. Put in 3.96 instead of 2.25 and see what you get with the same formula. Now you get Hours, minutes and seconds!! How do you get just Hours and minutes with the same number without having the "seconds" show.

Thanks

Change the format in the cell formetter:

Cell formatted as "H M S":

Cell formatted as "H M":

Guess I wrote too soon. If you click on the cell, then you can change the cells contents to whatever you want.