Recent content by JamesMichell

Thanks, and I appreciate the time you've already spent on this. I'm going to spend some more time on this later today and I may then post here with more information if I can't get the solution I want with the info you have already given me. Thanks again James

Skip, thanks for this. As a non programmer I'm going to have to spend some time working it out, but I'm not sure about it... James

Thanks for your quick reply. Am I right in thinking that the external workbook has to be open for Indirect to work? In which case this solution wouldn't work for me - but thanks anyway. Just to make it clear the part of my present formula which references the cell in the external sheets looks...

I have a spreadsheet which is summarizing data contained in up to 100 other spreadsheets. Each "external" sheet is named logically by the day and month and there are 2 per day; e.g 2610D.xls and 2610N.xls = 26th Oct Day/Night What I need is an easy way of referencing the same cell in...

Mike, More crossing posts...........! And your solutions open up a whole new range of possibilities. Thanks a lot. James

Blue, Sorry my last post crossed with your last post! Yes, with the time format that works fine and I understand the principal now, in that there are 86400 seconds in 24hrs. So if I was converting to minutes I would multiply by 1440........ That's great..thanks very much indeed.

Well, its Time, but in asking the question you've given me a clue. I could import the figures as text in which case one could take out the leading figure and then add 60 to the remainder. But at the moment it is in a Time format and it would be really useful to know how to convert it. Thanks...

I have columns of times in minutes and seconds and decimals of seconds e.g. 1:39.235 I need to show all these times in seconds and decimals of seconds e.g. 99.235 but formatted as a normal number. Is there a way of doing this?

Indu Many thanks for final the solution you found for me! As you discovered the problem was that the figures in the cells that were being called by the formulas had trailing spaces after them(imported from a text file)so of course excel didn't recognise them. The solution was to use the TRIM...

Indu, no problem. Just give me a bit of time to construct a subsection of it for you and I'll email it accross. James

Thanks, Glenn, and I did try the quotation marks to denote text but it makes no difference to the problem. And Indu, also. Your formula works just fine as long as I input the values directly into columns A and B. But when I put in the Index formulas, excel sees just those, and not the numeric...

In Excel I am using the INDEX function to find the value in a table at the junction of a column and a row. That works fine and gives me two values which are collected in columns A and B. Column C consists of a list of monetary values. I then need to collect the total of values in Column C where...