Excel Macro

  • Thread starter Thread starter Gina921
  • Start date Start date
G

Gina921

Is it possible to create a macro to apply a formula to selected cells? I
am importing data from AVAYA which displays elapsed time in seconds.
When copying into excel, the number displays but is not formatted as a
number. I want to create a macro that will recognize the number and
then apply a formula to convert it to hours and minutes. Any ideas?
 
Yes, it is possible.

But using a formula may not be the best way. If you post the values that get
pasted and what they should be when the macro finishes, I'm sure you'll get much
better help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select avaya cms server from shell option VBA 0
macro ignore formulas 3
pasting time from html 12
Formula on a dynamic range of cells 1
can Excel really deal with elapsed time? 1
Excel Macro for deleting Rows containing dates greater than "today" 0
Converting UTC timestamp value to date and time 1
problems getting this macro to work 23

Back
Top