Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hours multiplied by money | Excel Worksheet Functions | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
pounds multiplied by hours | Excel Worksheet Functions | |||
time format multiplied by hours worked ? | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |