Adding times 2

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

I tried the sugestions and it did not work. I have
imported this file from and ACD program and them saved it
as an Excel worksheet. Then I formatted as suggested and
it did not work at all.

I did type in a column myself and it worked on that. Any
idea why it does not work on the imported columns. I can't
firgure it out and it is driving me nuts. Is there
something hidden in the column that I cannot see.

Help....
 
When you start a new thread, you make it very difficult to understand
what you mean when you refer to previous suggestions (there've been over
400 posts in this group alone in the past 2 days, most people won't
look back through them to find something you wrote previously,
especially since you didn't use more than a first name).

Please reply in the original thread, or give a full description of what
you've tried and what you're trying to achieve.
 
I tried the sugestions and it did not work. I have
imported this file from and ACD program and them saved it
as an Excel worksheet. Then I formatted as suggested and
it did not work at all.

I did type in a column myself and it worked on that. Any
idea why it does not work on the imported columns. I can't
firgure it out and it is driving me nuts. Is there
something hidden in the column that I cannot see.
Click to expand...


It's probably imported as text. Are the times justified
to the left? If so place the number one in an unused
cell, copy it and "past special" - "multiply" to the
column of times. You may have to reformat it as time.

Jordon
 
Back
Top