Hi Chris,

Just multiply by 24 and format as General.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cab0419" wrote in message ...
| Hello Niek,
|
| Thanks for your answer but I'm afraid that I don't understand.
|
| The TIME function seems to require fields of hour, minute, second. My
| monthly totals are in a single cell formatted as HH:MM. The problem that I am
| having is separating off the hours if they are greater than 24. For example,
| If I have a cell of 35:28 what function do I need to use get the hours and
| minutes as a decimal (35.467)?
|
| Regards,
|
| Chris
|
| "Niek Otten" wrote:
|
| Times in Excel are stored as fractions of a day.
| So Time*24*Rate gives your required value
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "cab0419" wrote in message ...
| |I have set-up a worksheet that allows me to track start and stop times for
| | each client so I can have total billable hours for each client at the end of
| | the month. This works fine but I would like to take it one step further and
| | put in an hourly rate for each client and let Excel calcuate the amount to
| | invoice at the end of the month.
| |
| | The problem I am having is that I can't seem to separate the hours from the
| | minutes to do the calculation properly. Right now I hve a single cell
| | formatted with the total monthly hours and minutes. Often this number is
| | greater than 24 hours (ie 35:28). I want to multiply the total number of
| | hours and minutes by a dollar value and come up with a total dollar value for
| | the month.
| |
| | The MINUTE function seems to take care of the minutes fine. However the HOUR
| | function divides by 24 and returns only a number less than 24. This is not
| | acceptable for billable hours greater than 24 per month.
| |
| | Any ideas about how to get the right total?
|
|
|