# convert formula

1. ### 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. ### 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. ### Covert text to time

How do you convert Cells with text 2 hours 2 hours 1 hour 15 minutes to hh:mm ?
4. ### 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. ### 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. ### 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. ### 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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back