Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zetman
 
Posts: n/a
Default add, multiply then divide


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: http://www.excelforum.com/member.php...o&userid=31872
View this thread: http://www.excelforum.com/showthread...hreadid=515993

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default add, multiply then divide


If your minutes are in cells A1:A20

=SUM(A1:A20)*150/60


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515993

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zetman
 
Posts: n/a
Default add, multiply then divide


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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith
 
Posts: n/a
Default add, multiply then divide

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

--
Regards,
Fred


"Zetman" wrote in message
...

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiply two columns in Excel or one column by one number Axia's Mom New Users to Excel 1 January 12th 06 04:22 AM
Divide Column A by Column B multiply Column C Stumped Excel Worksheet Functions 3 December 28th 05 06:51 AM
how do I divide or multiply an entire column? 1number Excel Worksheet Functions 4 March 5th 05 09:48 PM
Divide one row over other row I dont wont to divide one number Rick Excel Discussion (Misc queries) 0 March 4th 05 08:13 PM
multiply by actual number in cell CJ Cerezo Excel Worksheet Functions 3 November 29th 04 10:43 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"