O.K. here it is!!!
I'm working on some sort of TimeCard.
Use in my sheet, vlookup, Now() and that kind of formulas.
Let's say I put Work Code like P1 in cell B4, that enters Description of kind of my work in D4 and start time in cell E4. After a minute I enter second work code in B5, that enters End time in F4 and How much time I needed for first event in G4 for first event and descrption for second event in D5 + start time in E5.
Problem is when I enter second event,
all times are the same so I can't calculate How much I use for first event.
I can solve this by macro, but I would like to solved this with formula.