close

Hi All,
I am not a regular user as you will certainly tell of Excel, but am
trying to come up with a worksheet for our company that computes how
long it takes to complete certain steps of an installation job. What I
need to do, in one column is to put a numerical value in minutes, this
will be over several cells, then have it add those numbers, multiply it
by 150, which is the number of items I am setting it up to figure, then
divide that number by 60, to come up with total hours to complete the
job. Hope that makes sense and thanks to anyone offering any help.--
Zetman
------------------------------------------------------------------------
Zetman's Profile: www.excelforum.com/member.php...oamp;userid=31872
View this thread: www.excelforum.com/showthread...hreadid=515993
If your minutes are in cells A1:A20

=SUM(A1:A20)*150/60--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=515993
geezzz..that was easy. thanks so much for the quick answer. I wish I
would of found this forum about 5 hours ago--
Zetman
------------------------------------------------------------------------
Zetman's Profile: www.excelforum.com/member.php...oamp;userid=31872
View this thread: www.excelforum.com/showthread...hreadid=515993You're right, Zetman. The Excel gurus on this forum are amazing. And easy to get
along with, too.

--
Regards,
Fredquot;Zetmanquot; gt; wrote in message
...
gt;
gt; geezzz..that was easy. thanks so much for the quick answer. I wish I
gt; would of found this forum about 5 hours ago
gt;
gt;
gt; --
gt; Zetman
gt; ------------------------------------------------------------------------
gt; Zetman's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31872
gt; View this thread: www.excelforum.com/showthread...hreadid=515993
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()