Automatic copy of a particular cell value to another based on a condition

In an excel sheet

Column A has the name of the groups
COlumn B has either IN or Out based on "=IF(G>0,"OUT","IN")"
column C has the number of agents in the corresponding groups in column A
COlumn D indicates the application on which Groups are logged in
COlumn E has the login time in format hh:MM
COlumn F has logout time in format HH:MM
COlumn G has the total login hour for that session calculated based on "=(F-E)*C"
Column H has the name of the location from which the group is and is obtained by "=VLOOKUP(A3,J:N,5,0)"
COlumn I has the date in format mm/dd/yyyy
COlumn J has the name of the groups again
COlumn K has the original count
COlumn L has the last logout time based on "=LOOKUP(2,1/($A$2:$A$761=J2),$F$2:$F$761)"
Column M has the name of the application where the groups are logged in and fetcher from Column D by formula "=LOOKUP(2,1/($A$2:$A$761=J2),$D$2:$D$761)"
Column N has the name of the location which we manually enter
Column O has the shift login time of the corresponding group
COlumn P has the shift logout time of the corresponding group
Column Q shows whether the group is logged in or logged out based on "=IF(L3=0, "IN", "OUT")"


now whenever we make any new entry in column a
and when we add time in column E of the same row

is it possible that to automatically copy the column E cell(Latest manual entry) time value to column F cell of second last entry of the same group

Demo_Test.xlsm

Perhaps the following will help.
1. Convert the data range into an Excel table
2. Populate column F using: =IFERROR(INDEX([Login],AGGREGATE(15,6,(ROW([Login])-ROW(Table1[#Headers]))/([Groups]=[@Groups])/(ROW([Groups])>ROW([@Groups])),1)),"")
Let us know if you have any questions.
Edit: Some of the other columns displayed errors after the range was converted to a table and the formula was added in column F. I believe those columns are now displaying correctly.