It was the "format as general" that was the key. Works perfectly. Thanks for
your help.

Chris

"cab0419" wrote:

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?