does anybody know some solution for the next:
I have a column with some time data on the next format (e.g.):
00:01:28 which means 1 minute and 28 seconds. I would like to see this data
expressed with numbers as 1,46 minutes.

hi everyone I want to write a sub that converts all values of two
consecutive columns(C1:D190) from c degree to f degree.I know the
formula but don't know how to apply it to all cells I'm completely
confused .This is part of my school project and I don't know how to do

Is there any way I can have five conditional formats in one cell
thanks

Can someone tell me why this formula gives me an error message?  It works for
0 thru 5 but when i add the sixth or more it errors out.
Thanks, John
=IF(10-COUNTBLANK(F3:O3)=0,TRUNC(SUM(F3:O3)+C3),

Hi group,
I got the following formula from Niek Otten in this group a couple of months
ago.
=IF(LEN(C7)=9,C7&"/1",LEFT(C7,10)&RIGHT(C7,1)+1)

I have a number of individual workbooks that execute a macro automatically
on load (it modifies the protection).
I also have a big 'consolidation' workbook that collates the info from all
the individual workbooks. The Consolidation opens the individual books

Urgent work! I have two excel membership database, Club A & Club B.
I need to find out all the members who join Club A & B, and Club A members
who haven't join Club B. I will need to check it by tracing the IC(unique:
combine characters & numbers)

Hi I hope I can explain this easily without confusion.  I have 12 sheets
each representing the months of the year ie Jan,Feb, Mar etc.  Then I have a
summary sheet called Summary which I want to be able to display certain
values from one of the 12 sheets.  The deciding factor will ...

I do not seem to have the equal sign on my formula bar. how do i receive this?

I am trying to view different worksheets across two screens (to compare, cut
and paste etc.) as I can with Word docs -- but can only open sheets within
the one Excel frame and window -- which is really annoying. Any ideas?
Many thanks...

I have a workbook (weekly financial workbooks) that contains worksheets that
have links to another workbook. They are in different directories.
When the workbook is finished I save it. When I open it again I get asked it
I want to update the links...I say no...I then open another ...

How can include tooltips on an form option button object? and Where can I go
to modify the tab properties for each individual textbox? I tried everything
on the properties. Please help.
thanks,

I would like to use this:
+vlookup(value, data range, col, false)
data range = start position:B20
the value of the start position is stored in cell D1, it is

Would like your help to advise on ow to set a formula on the following
Example : for 4/13/2006 11:22, how to set a formula to convert the US
mountain time to Asia/Singapore time?
US mountain time     Convert to Asia/Singapore time

I have a formula that I want to use to generate (depending on the situation)
a blank value. I thought a null string ("") was equivalent to a blank but
that doesn't seem to be the case.
Here's my example: