Prev Previous Post   Next Post Next
  #1   Report Post  
Gina921
 
Posts: n/a
Default Excel Macro


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?


--
Gina921
------------------------------------------------------------------------
Gina921's Profile: http://www.excelforum.com/member.php...o&userid=24759
View this thread: http://www.excelforum.com/showthread...hreadid=383301

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Excel using Macro mrbalaje Excel Discussion (Misc queries) 4 April 20th 05 02:32 PM
How do I find a Macro in Excel when I don't know its name? LLEECEE Excel Discussion (Misc queries) 2 March 31st 05 10:28 PM
How can I edit cell contents with a macro in Excel? Mind the gaps! Excel Discussion (Misc queries) 2 March 23rd 05 08:51 PM
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 1 March 19th 05 06:43 PM
Open Access Database under and Excel window using a Macro BMSpell Excel Worksheet Functions 1 January 8th 05 05:32 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"