Thread
:
need column with 00:00:00 like stopwatch x's a number donemonthly
View Single Post
#
2
Nick Hodge
Posts: n/a
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 With Quote