Search results

Thank u guys. Here's how i did it. 1. Format cells A1 & A2 as: dd/mm/yyyy hh:mm:ss 2. cell A1 = 19/06/2013 11:00:00 pm 3. cell A2 = 20/06/2013 11:00:00 am 4. cell A3 = TEXT(A2-A1,"dd:hh:mm") = 00:12:00 Best wishes, James

Hello guys, How do i substract Date and Time in Excel ?? I have my data below: A1 = 13/06/2013 15:47 PM A2 = 14/06/2013 09:30 AM I want to calculate difference in Day and Time Format in single cell. ThanX.

Very many thanks Narayan. That was so cool! Stay blessed. James

Hello Ninjas & members. Out of curiosity i simply enjoyed trying it all out. Graćias.

Hello Narayan & thank u 4 ur interest. Its like this: In columnA, A1:A21 i have GlobalSalesRep1 thru GlobalSalesRep21. In columnB, B1:B21 i have the names of 21 countries. (each GSR represents just one country & that's fixed.) For now, i'd like to do a "switch". That is, all the values in...

Hello friends. Cells A2:A21 contain values like ExportRep1 thru ExportRep21. Cols A1:C1 contain values like Jan Feb Mar Data_Range B2:D22 contain names of 21 countries. Here's the Q. The countries in Jan r repeated in Feb and again in Mar. How do i "switch" the Countries with Export Reps &...

Hey! All u great fans of chandoo.org r most welcome.

Thank you all!!! :-) Much appreciated. Here's how i finally managed to solve the problem. I have two seprate columns for last name & first name and so i used this formula: =B1 & " " & A1 (B1 is last name & A1 is first name) Best wishes, James

Thanks oldchippy. Stay blessed.

Thank you all!!! :-) I think it would be easier to just replace the email addresses with a blank. Here's how i did it. ( Keeping it simple.) 1. Press Ctrl+H. 2. Notice that the email addresses has this pattern, <email@address.com>. 3. In the "Find What" field, enter <*&#62...

Thank you all!!! :-) Much appreciated. James