Converting time to numeric number

  • Thread starter Thread starter brazpearl
  • Start date Start date
B

brazpearl

I need to know from someone about converting time into a numeric number
Ex. I need to convert 8:00:00 to the #8 so i can divide the 8 hour
into how many sales a person worked during that time to find out ho
many sales were made per hour worked? HELP ME PLEASE AND VERY FAS
PLEAS
 
brazpearl said:
I need to know from someone about converting time into a numeric number.
Ex. I need to convert 8:00:00 to the #8 so i can divide the 8 hours
into how many sales a person worked during that time to find out how
many sales were made per hour worked?
Click to expand...

Assuming that your time value is the result of a calculation (i.e. end
time - start time) and not a directly entered value, you can convert time
into hours by multiplying by 24. So if you have:

A
1 12:00 PM
2 8:00 PM
3 =A2-A1
4 =A3*24

Cell A4 will have the number of hours worked as a regular number, rather
than Excel's DateSerial notation. Be sure to change the number format of
cell A4 to General after you enter the formula or you'll get a strange
looking result because it will be given a DateTime format by default.

--
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 *
 
I THANK YOU FOR TRYING BUT IT IS A BIT MORE DIFFICULT THAN THAT LET M
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 TAK
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 THE
TAKE THE SALES IN THE SALES WORKSHEET DIVIDE THEN AND POPULATE TH
SALES PER HOUR. QUESTION HOW DO I COME UP WITH SUCH A FORMULA WITH OU
CREATING ANOTHER COLUMN. TO DO WHAT I NEED IT TO.
YOUR ANSWERS WERE SIMLPLE IF I WAS DOING IT THAT WAY. i NEED ON
REALLY BIG FORMULA TO DO IT ALL.
I HOPE THIS IS CLEARLY TO WHAT I NEED HELP WITH.:confused
 
As you said, your formula is rather complicated. Would you mind disclos
your formula you write.

Raymon
 
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 *
 
=24/(8:00:00*24)
Slaes divided by times to get sales per hour yes but an error messag
comes up
if you are talking like this then there is an error.
the hours need to be in this format 8:00:00 and then converted to thi
format 8 a whole numeric numer or a decimal number for your formula t
work.

Again thanks for the effort. I will keep trying any suggestions
 
If you want to enter the actual time in the formula itself you'll have
to do it like this:

=24/(TIMEVALUE("8:00:00")*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 *
 
Back
Top