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

J

Jeremy Flisher

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)
 
Top