How to change hour format to text but not changing the number ?

Hi All,
I try to find the way to change the hour format to text but not changing the number
Example
10:30 ( format as 10:30:00 AM) ==> Want to change to 10.30
225:00 ( format 1/9/1900 9:00:00 AM) ==> want to change to 225.00

The 10:30 and 225:00 are should not be hours format but equal to how many hour and minutes
10:30 = 10 hours and 30 mins
225:00 = 225 hours

The reason is I want to use pivot table but the result (sum) is incorrect as it represent hour
Please see Book1 attached for more explanation.

Thank you in advance for your help

It seems like your formula to sum up all of the yellow times is accurate. The sum of column D (green) is not because 30 minutes doesn't equal 3/10ths of an hour. 30 Minutes is actually 5/10ths of an hour, so a time of 10:30 would be translated to 10.5 in your example.

This article talks about the correct custom format to be able to sum quantities of time (Column B) in your sheet. It appears they are already formatted correctly.

How to Add, or Sum, Time Values in Excel