How do I multiply dollars by time?

M

Mike R.

I am creating a spreadsheet that calculates hours and minutes worked and want to multiply the result by the hourly rate expressed in dollars. Judging by the result I get using the standard time and currency formats, the two format types are not compatible.
 
J

Jake Marx

Hi Mike R.,
I am creating a spreadsheet that calculates hours and minutes worked
and want to multiply the result by the hourly rate expressed in
dollars. Judging by the result I get using the standard time and
currency formats, the two format types are not compatible.

If you entered the values as actual times (eg, 8:30 for 8 hours and 30
minutes), then the values are being stored as fractional parts of days. So
if you put in 8:00, which is 1/3 of a day, the approximate value stored in
the cell is .3333. It's just that the cell is formatted to look like a
time.

So, in order to get to the number of hours, you need to multiply by 24. If
your times are in column A and your hourly rates are in column B, you can do
this:

=A2 * B2 * 24

Just format it as currency and you should be all set.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top