How do I add military time from one cell with minutes from another cell and
also show the change in the hours?
aka....0600 and add 60 min to make 0700....and 0635 add 35 min to make 0710
thanks in advance

Here is my set up. I have a sheet of data about 35,000 lines in in cloumn
"J" I would like to search for the text "Jump" in the entire column and when
I find it I want to copy that whole row of data along with the Heading &
format of the data sheet to a new sheet and name the ...

I am trying to populate a cell in one worksheet with data from another
worksheet within the same workbook. The source worksheet (sheet 1) has
a numbered column (Column A) but the numbers do not necessarily match
the cell’s row numbers. The data I want to capture from the source is

I have created a macro in the visual basic editor of my excel file, but I
don't know how to auto activate the macro whenever this file is opened or
when "Shift" &":" buttons are pressed.  Can someone teach me how to make this
happen.

I want to perform an sumproduct type of function with on column of data (1 x
n) and the minimum value in each row of a 2 x n matrix.  Is there a simple
formula that will allow me to do this.  I know that I could create a new
column with the minimums or that I could brute force ...

readings on power usage three times a day for every day of the month.
The month and year is entered at the top of the sheet, and the day
cells in the sheet will format fine.   The sheet has enough room for

I received a spreadsheet with a font I'm unable to change.  The font style
is "ＭＳ Ｐゴシック".  It makes the cell contents looks spaced out, like this:
Ｄ３８９９９／２０ＫＨ５３ＳＡ
 Nothing I've done changes the way the font looks.  

I need to have some cells add and delete in one column.  At the end of each
day i need to clear everything out, but have the total at the bottom of the
page appear at the top of the column.  I have tried this, but when ever i hit
the clear macro, it puts a zero at the top.  Any ...

When i use If-Array formula to return me multiple values, I get th
desired result but the prob is that wherever the condition fails i
puts '0' (or Blank). for instance:
A3: Abc

I am trying to create a spreadsheet for work to validate SIN numbers.
This is the formula in it's non spreadsheet form:
http://www.pwgsc.gc.ca/compensation/ppim/ppim-5-1-e.html
SIN VALIDATION

Hello. I'm stuck once again, and I've come to the greatest place on the
web to seek help! I've learned so much from asking questions and also
reading what others are learning to do.
I'm working on a sheet where:

I made a spreadsheet with 3 columns of numbers and 1 of dates.  It is roughly
600 lines long, but when I try to "find" a value it comes back as not in
spreadsheet even though I see the value listed.
thanks

appreciate if anyone teach me how to do a hyperlink to a unopen file. so
that i could open the file every time i click the button.
thanks in advance...
lawrence

when I email to other people my worksheet, I don't know how to hide the
unnecessary sheets, so I just let my customers see what they should know.

I'm in desperate need of the help of one of you resident genius'. I'm
not quite sure how to approach this one.
I'm trying to build a very simple scheduling tool to improve the
decision making process behind the booking of meetings in an