Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hour multiply by a value
It's like this: in one cell I have the sum of some cells with a number of hours made by a worker in that week, something like: 42:36:00 And on another cell i've got the amount of €(euros) I pay by hour to a worker. by example, 5. So what I want to do is: arrange a way to know how much i'm going to pay him at the end of the week. I've tried working with the HOUR and MINUTE commands. but with the HOUR i will only go up to 23, so it doesn't work. Help... -- FixxxeR ------------------------------------------------------------------------ FixxxeR's Profile: http://www.excelforum.com/member.php...o&userid=29798 View this thread: http://www.excelforum.com/showthread...hreadid=495071 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Round Time with Conditions | Charts and Charting in Excel | |||
How do I multiply rate per hour by hours worked. | Excel Worksheet Functions | |||
How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions |