convert formula

  1. A

    Method to convert Formulas to Fix values automatically based on real time

    Hello guys! Is the any method to convert Formulas to Fix values automatically based on real time? I need this to work out with my file. Thanks a lot!
  2. Y

    Convert Alpha to Phone keypad numeric

    Is there an easy excel formula that I can use to create id numbers for a list of students using the first initial of their first name and the first four digits of their last name? I'd like to take those five letters and convert them to the corresponding numbers on a telephone keypad. For...
  3. M

    Covert text to time

    How do you convert Cells with text 2 hours 2 hours 1 hour 15 minutes to hh:mm ?
  4. The_Rock

    DSUM from Lotus 123 to Excel

    Hi folks, I've been searching hard for an answer to this but cannot figure it out. I'm hoping your genius minds will have the solution to this. I'm in the process of updating a 123 sheet to Excel. I have the following data; Column E = Opportunity Column F = Row Column G = Amount Column H = Curr...
  5. D

    Convert cummlative hh:mm:ss to minutes

    I have a report that lists the amount of time people are logged out of a call center for various reasons. The time is cummulative for the day. I would like to add up the cummulative times for each reason and person for a month but the format is hh:mm:ss. I need to convert this to minutes...
  6. R

    Do I need convert formula into vba?

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have written a formula to calculate an average price, plus or minus commission, if the values in each column conform to the following criteria: <o:p></o:p> If column B = AH, C = Buy and F = 3...
  7. K

    converting days and hours, mins, and sec

    I have a report that generates into excel everyday from our avaya system. But if it is more than 24 hours in a time period, it will show up like this, for example: 2d 18:11:49 For my report and formulas, I need it to be in hours, minutes, seconds, so I have to manually change it to 66:11:49...

Some videos you may like

This Week's Hot Topics