Cell format of Custom [h]:mm; working with question?

[JGExcel]

Is there a way to take a cell formatted as Custom [h]:mm (which displays total time as 40:45 - hours and minutes) as 40.75 Hours (hours and percentage of hour for the remaining minutes)?

Thanks in advance.

 

[Aladin Akyurek]

On 2002-05-01 05:10, JGExcel wrote:
Is there a way to take a cell formatted as Custom [h]:mm (which displays total time as 40:45 - hours and minutes) as 40.75 Hours (hours and percentage of hour for the remaining minutes)?

Thanks in advance.

=A1*24

where A1 houses a value like 40:45.

Format the formula cell as General.

 

[JGExcel]

Aladin, I am most thankful for your advise. It works like a charm as you know. I hope you too can get your questions answered so quickly and successfully.

Best wishes!