Recent content by KN3M3SIS

Yeah, but your forumula didn't account for trimming the cell down. I attempted for format the cells but nothing changed. The new formula worked GREAT. Thanks to all.

I havent' attempted to use a formula yet. I need a formula that will find the difference between the two dates and return the number of days.

My objective is get (2003-11-14-16.02.55.000000)-(2003-11-13-14.17.16.000000) = Difference in days. I am unable to change the format to properly convert it so is there a formula or something that will trim and reformat so that the date function will work?

The cells as they aren't won't reformat to fit what's required. Is there a way to change/fix this without re-entering all of the data manually? Thanks

I guess an additional question is what is needed to get the date format properly formatted to properly calculate the difference. Right now they are reading in: Year-Month-Date-Hour.Min.Sec.000000 Please advise.

Date 1 Date 2 2003-11-13-14.17.16.000000 2003-11-14-16.02.55.000000 2003-11-06-08.14.32.000000 2003-11-06-10.28.03.000000 2003-10-31-13.22.19.000000 2003-11-13-12.14.07.000000 I have 2 fields (Date 1 and Date 2). I need a forumla to calculate the numbers of days...

I have many cells that reference and make calculations from other cells. When these cells have no infomration in them they dislay "#DIV" or "0" or whatever else. I do not want the cells to have anything in them until something is entered. Is there a way to keep the...

I have a table in acces. Name >> Position >> Hours I need for letters to be printed for each name and the corresponding data. In the event that the same name pops up twice, which will happen, how can I have access or word print out those 2 lines on the same letter for that person? The tables...

Thank you for your response. I've never printed excel information in word. Could you help me or point me towards a reference sheet to use. Thank you in advance.

I have about 300 Rows on an EXCEL sheet that I need to print. I need for each line to print on a seperate page with the headers included. How can this be done?

Thanks for a prompt reply, but it is not working. I'm not understanding the "D2=37500" value. Did this work for you? Please advise as I am stuck

Name Desc Review Date Berry asc O 9/01/02 Berry asc V 9/01/01 Berry asc E 9/01/00 Jamie salk V 9/01/02 Jamie salk V 9/01/01 Jamie salk V 9/01/00 Michelle rep U 9/01/02 Michelle rep U...

I have to colums with similar data. Some are the same and some aren't. Colum "A:26" may have the number 987.23 and colum "B:26" may have 987.29... I need a formula that compare two adjacent cells and flags them by bolding or return a value in a differnt cell if they are...

I've recently used a formula that allowed me to take a start date and coompare it to the current date and it returns the number of TOTAL DAYS. Is there anyway that I can have it return the total number of months instead of days? Please advise, Thanks in advance.

So I have a column with number that range from 0 - 2, then I have another that has some letters in it. I want to be able to do something like. If N# > 1 add the letter "A" to the string in B# Else add the letter "B" Example N B RESULT 1.4 VE AVE .9...