Excel Macro

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?
 
D

Dave Peterson

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.
 
Top