Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need column with 00:00:00 like stopwatch x's a number donemonthly
I have a column that is the time it takes to do a task.(hh:mm:ss). I have a column that is the number of tasks per month. I have a column that should be the result of the first and second column. This will sometimes be only seconds a task or minutes a task. Then I need a fourth column that would be the total money this montly task would take if 1 hour would cost #100.00. You can tell I am not an accounting person. I can find no way to solve this. Help |
#2
|
|||
|
|||
Blusty
In C1 enter =A1*B1 format as [hh]:mm:ss (the brackets will stop the hours over 24 incrementing to days) Then in D1 enter =(C1*24)*100 formatted as currency You may wish to check out http://www.cpearson.com/excel/datetime.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Blusty" wrote in message ... I have a column that is the time it takes to do a task.(hh:mm:ss). I have a column that is the number of tasks per month. I have a column that should be the result of the first and second column. This will sometimes be only seconds a task or minutes a task. Then I need a fourth column that would be the total money this montly task would take if 1 hour would cost #100.00. You can tell I am not an accounting person. I can find no way to solve this. Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) |