| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hours and minutes multiplied by wage
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 its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hours and minutes multiplied by wage
=A1*B1*24
Time in Excel is stored as a fraction of a day, so 1 hour = 1/24 -- Kind regards, Niek Otten "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 its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hours and minutes multiplied by wage
Sorry, confused Columns and Rows
=A1*A2*24 -- Kind regards, Niek Otten "Niek Otten" wrote in message ... =A1*B1*24 Time in Excel is stored as a fraction of a day, so 1 hour = 1/24 -- Kind regards, Niek Otten "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 its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hours and minutes multiplied by wage
See previous post.
-- 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 its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hours and minutes multiplied by wage
PLEASE POST YOUR QUESTION ONCE AND ONLY ONCE!
This is your third posting of the same problem. See my answer to your first post "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 its not exact. I think thats because its counting the time wrong, but am not sure. Any help would be apprecitated. Thank you, Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| How to convert minutes to fractional hours | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
Hybrid Mode
