add, multiply then divide

[Zetman]

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.

[daddylonglegs]

If your minutes are in cells A1:A20

=SUM(A1:A20)*150/60

[Zetman]

geezzz..that was easy. thanks so much for the quick answer. I wish I would of found this forum about 5 hours ago

[Fred Smith]

You're right, Zetman. The Excel gurus on this forum are amazing. And easy to get
along with, too.

--
Regards,
Fred


"Zetman" <[email protected]> wrote in message
news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=31872
> View this thread: http://www.excelforum.com/showthread...hreadid=515993
>