how do i multiply hours:minutes by a cash value?
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? |
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? |
All times are GMT +1. The time now is 06:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com