how do i multiply hours:minutes by a cash value?

G

Guest

doing a project spread sheet using custom format hh:mm to record volunteer
hours.
Problem 1 - volunteers who have contributed > 24 hours return the wrong
answer when hours totalled )i.e. seems to go back to zero when 24 hours
reached)
problem 2 how do I multiply the totla individual hours by the individual
hourly rates to obtain a total value?
 
B

Bob Phillips

24 hours: format the cell as [hh]:mm

=Hours_worked*24*rate

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Similar Threads

how can I multiply number of hours and minutes by hourly rate? 5
how to multiply h:mm value by an hourly $ rate 2
How to multiply hours by a dollar amount 3
How do I multiply rate per hour by hours worked. 1
How do I set up a spread sheet that will add my hours work in h:mm 2
How do I multiply dollars by time? 1
How do i multiply an hourly rate by hours in Excel? 2
How do I lock a sub form when a summary value has been reached? 4

Top