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

=Hours_worked*24*rate

--

HTH

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


"Jeremy Flisher" <Jeremy wrote in message
...
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?