extracting hours from a sum of time

[benami]

I have a cell which sum a bunch of cells containing an elapsed time.
The sum totals to more than 24 hours.
I have to a cell with a cost per hour and I need to caclculate the
total cost.
The problem is that the hour function returns values in the range of
0-24. My current sum is 25:30 and the hour function return 1 and not
25.
Any ideas how to bypass it?

 

[Niek Otten]

It "returns" the correct number, but doesn't show. Format Custom as [h]:mm and it will.
To convert to a number that you can multiply with an hourly rate, first multiply by 24; times in Excel are fractions of a day and
a day is stored as the number 1.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have a cell which sum a bunch of cells containing an elapsed time.
| The sum totals to more than 24 hours.
| I have to a cell with a cost per hour and I need to caclculate the
| total cost.
| The problem is that the hour function returns values in the range of
| 0-24. My current sum is 25:30 and the hour function return 1 and not
| 25.
| Any ideas how to bypass it?