extracting hours from a sum of time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

benami@gmail.com - 29 Jan 2008 20:15 GMT

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?

Reply to this Message

Niek Otten - 29 Jan 2008 20:22 GMT

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.

Signature

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.
[quoted text clipped - 4 lines]
| 25.
| Any ideas how to bypass it?

Reply to this Message