Windows 10: How Do I derive values from 2 different cells and put them in one cell?

How Do I derive values from 2 different cells and put them in one cell in Excel. This one cell needs to get a date from a column and then get time from another column and combine it to a date and time stamp.

:)

 

Hiding values in cells

Hi all,
I have drawn a blank on how to hide cells that are empty, as in no data to display.
I set up the formula and it calculates properly, but if it gets to an empty cell, it will continue to display the results from the previous cell all the way to the bottom of the sheet, see picture below.
Would like some help in hiding the cells that don’t have any data yet. I have done that before, but can’t remember how I did it.
Thanks
Sven

 

Hiding values in cells

Hi Sven1458. Here is how to do it. Assuming the the Credit Column is "F" and the Debit Column is "G" and the Balance Column is "H" ans the last row (with 1,000.00) in it is "50" then the formula you want to put in the Balance cell is:
=IF(AND(ISBLANK(F50),ISBLANK(G50)),"",OFFSET(H50,-1,0,1,1)-F50+G50)
what this formula says is:
if the two cells to the left are empty then the subject cell is blank, if not then it is equal to the algebraic sum of the cell immediately above and any credit or deposit to the left.

Be sure to copy the formula correctly. Let me know how it works for you.

 

Identify gaps in a sequence in one cell - Excel

Your problem can be solved by using the TREND function:

1. Taking the first data sample in Column A, you need to create 1st sequence from 1 to 13 and 2nd from 1 to 20.
   
2. Write this Array Formula in Cell C1, finish with Ctrl+Shift+Enter & fill down.
   

{=TREND(A1:A13,B1:B13,B14:B20)}

1. You get series from 14 to 20.
   
2. In D1 enter this Formula to get the 1st Cell value.
   =INDEX(C1:C7,MATCH(TRUE,INDEX((C1:C7<>0),0),0))
   
3. Enter this Formula in D2 to get last Cell value.
   

=LOOKUP(2,1/(C1:C7<>""),C1:C7)

1. In Cell D4 enter this one =D1&"-"&D2, you get 14-20.
   

Note:
For 2nd data sample you need to create 2 series.

1- 2 to 9.

2- 1 to 10.

3rd data sample needs 3 series.

1- 1 to 4.

2- 6 to 11.

3- 1 to 11.

1. Repeat the above shown steps for other data samples.
   
2. Adjust cell references in the Formula as needed.