![]() |
hours multiplied by money
I'm trying to make 3 rows. The first is hours and minutes, the second is
wage, and the third is total. I tried using one of Office XP Professional formula's, but it isn't not exact. I think thats because its counting the tim wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
hours multiplied by money
You'll probably find all you need to know at Chip Pearson's site. See this
page and the links from there to other date/time subjects http://www.cpearson.com/excel/datetime.htm#AddingTimes "Tom" wrote: I'm trying to make 3 rows. The first is hours and minutes, the second is wage, and the third is total. I tried using one of Office XP Professional formula's, but it isn't not exact. I think thats because its counting the tim wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
hours multiplied by money
=A1*24*A2
where A1 is the time, A2 is the rate -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Tom" wrote in message ... I'm trying to make 3 rows. The first is hours and minutes, the second is wage, and the third is total. I tried using one of Office XP Professional formula's, but it isn't not exact. I think thats because its counting the tim wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com