convert formula

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!

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

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

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

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

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

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