Formula Creation/Formula Help

[yessir]

Is there a combination of formulas that can distinguish what is in column A, and tell me what's changed (or stayed the same) when the date changes in F and D. An example is there is an additional 1 on 6/1/2020 from 10:04(column B) to 11:00(column C) that wasn't there on 5/1/2020(column F). Any help is very much appreciated.

I've listed an example of what it might look like below. Ideally it would return what I've put in column H. Not sure how the formatting would work but more curious about how to achieve those results automatically.

A	B	C	D	E	F	G	H
Name	Start Time	End Time	6/1/2020	Total	5/1/2020	Total	Addition/Loss
AAA	10:04	11:00	1	10,868			10:04-11:00 Addition
AAA	11:19	12:10			1	10,868	11:19-12:10 Loss
AAA	13:51	14:45	1	10,868			13:51-14:45 Addition
AAA	15:40	16:35	1	10,868			15:40-16:35 Addition
AAA	21:47	22:40	1	10,868	1	10,868	21:47-22:40 Maintained
BBB	11:53	12:30	1	25,000			11:53-12:30 Addition
BBB	12:45	13:20			1	25,000	12:45-13:20 Loss
BBB	20:31	21:05	1	25,000			20:31-21:05 Addition

Any help is appreciated! Thanks!

 

[FuNeS13]

try putting this formula in H2 and drag it down...

=IF(D3>F3,TEXT(B3,"HH:MM")&" -"&TEXT(C3,"HH:MM")&" Addition",IF(D3<F3,TEXT(B3,"HH:MM")&" -"&TEXT(C3,"HH:MM")&" Loss",TEXT(B3,"HH:MM")&" -"&TEXT(C3,"HH:MM")&" Maintained"))

 

[yessir]

Thanks so much for your help! @FuNeS13 . Would it be possible to have the format being something like this?

A	B	C	D	E	F	G	H
Name	Start Time	End Time	6/1/2020	Total	5/1/2020	Total	Addition/Loss
AAA	10:04	11:00	1	10,868			AAA 10:04-11:00 Addition 11:19-12:10 Loss 13:51-14:45 Addition 15:40-16:35 Addition 21:47-22:40 Maintained
AAA	11:19	12:10			1	10,868
AAA	13:51	14:45	1	10,868
AAA	15:40	16:35	1	10,868
AAA	21:47	22:40	1	10,868	1	10,868
BBB	11:53	12:30	1	25,000			BBB 11:53-12:30 Addition 12:45-13:20 Loss 20:31-21:05 Addition
BBB	12:45	13:20			1	25,000
BBB	20:31	21:05	1	25,000

If not it's all good, I'm just wondering! Anything is appreciated.

 

[FuNeS13]

I'm sure it can be done, however you need a smarter mind to help you, someone like @DanteAmor or @Fluff would do it in no time...

 

[yessir]

Gotcha! Well I appreciate your help so far and hopefully @Fluff or @DanteAmor might take a look!

 

[DanteAmor]

Would it be possible to have the format being something like this?

You could update your Account details with your office version and Platform.

With version excel 365 or 2019, you can use the TextJoin function to concatenate multiple results into one cell.
Look at the syntax:

TEXTJOIN function - Microsoft Support

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

support.microsoft.com

If you don't have any of those versions then it would have to be with VBA code.

I don't have those versions, so if you want, I could help you with the code.