simple timesheet
I am trying to take an elapsed time, say 1:45 hrs, and multiple by $12
per hour and have the correct final amount. Suggestions please. Thank you Larry |
simple timesheet
If A1 contained the time (hh:mm) and B1 contained the $12, then you could use:
=a1*24*b1 Larry wrote: I am trying to take an elapsed time, say 1:45 hrs, and multiple by $12 per hour and have the correct final amount. Suggestions please. Thank you Larry -- Dave Peterson |
simple timesheet
Dave Peterson explained on 7/01/08 :
If A1 contained the time (hh:mm) and B1 contained the $12, then you could use: =a1*24*b1 Larry wrote: I am trying to take an elapsed time, say 1:45 hrs, and multiple by $12 per hour and have the correct final amount. Suggestions please. Thank you Larry very simple and it works - thank you very much Larry |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com