Multiply hours by dollars for timesheet or invoice

[gk]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)

I have a monthly timesheet where I track my hours.

I use the format code [hh]:mm to display the grand total of hours in order to display a number of hours greater than 24, as I regrettably must work more than 24 hours in a month.

How can I multiply this value - eg.) 240:30 by my hourly dollar rate? There must be an easy way to do this, and as you can see, I don't have much time to figure it out!

(The hour() function returns an integer between 0 and 24, so is not helpful.)

 

[JE McGimpsey]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)

I have a monthly timesheet where I track my hours.

I use the format code [hh]:mm to display the grand total of hours in order to
display a number of hours greater than 24, as I regrettably must work more
than 24 hours in a month.

How can I multiply this value - eg.) 240:30 by my hourly dollar rate? There
must be an easy way to do this, and as you can see, I don't have much time to
figure it out!

(The hour() function returns an integer between 0 and 24, so is not helpful.)

XL stores times as fractional days, so 6:00:00 = 0.25

Thus you can use

A1: 240:30
A2: <hourly rate>
A3: =(A1 * 24) * A2