The formula is not very complicated based on your description. Assuming
you have hours as a DateTime in cell A3 on the Hours worksheet and you have
Sales as some number of units in cell A3 on the Sales worksheet, then the
formula to calculate sales per hour on your Overview worksheet would simply
be:

=Sales!A3/(Hours!A3*24)

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"brazpearl" wrote in message
...

I THANK YOU FOR TRYING BUT IT IS A BIT MORE DIFFICULT THAN THAT LET ME
EXPLAIN A BIT BETTER.



WORKSHEET CALLED HOURS HAS ALL THE HOURS
IN THE FORMAT 8:00:00 FOR EXAMPLE
THEN IN WORKSHEET CALL SALES
IN AN OVERVIEW WORKSHEET I NEED TO COME UP WITH A LONG FORMULA TO TAKE
OF IT ALL
FOR THE COLUMN SALES PER HOUR TO CALCULATE
SO IT NEEDS TO TAKE THE 8:00:00 IN A FORMULA CONVERT TO A NUMBER THEN
TAKE THE SALES IN THE SALES WORKSHEET DIVIDE THEN AND POPULATE THE
SALES PER HOUR. QUESTION HOW DO I COME UP WITH SUCH A FORMULA WITH OUT
CREATING ANOTHER COLUMN. TO DO WHAT I NEED IT TO.
YOUR ANSWERS WERE SIMLPLE IF I WAS DOING IT THAT WAY. i NEED ONE
REALLY BIG FORMULA TO DO IT ALL.
I HOPE THIS IS CLEARLY TO WHAT I NEED HELP WITH.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/