Please help
I have a spreadsheet that manages queries on a daily basis, each entry is time managed by a userform (ie timer starts when form opened and stops when closed) the start, stop and elapsed time get input on the log. This log is used by several people daily.
the formula i have at the moment is =IFERROR(INDEX(Inputs!$A$1:$L$3500,SMALL(IF(Inputs!$G$1:$G$3500='Cumulativetime'!$A$1,ROW(Inputs!$G$1:$G$3500)),ROW(Inputs!1:1)),12),"")
this formula works fine for daily time recording, but what i am looking to do is be able to have a dropdown in the cumulative time sheet (M1) for each person and have a formula that can generate the daily time for each person given a specified date in cumulativetime A1
i hope this makes sense
thanks in advance
I have a spreadsheet that manages queries on a daily basis, each entry is time managed by a userform (ie timer starts when form opened and stops when closed) the start, stop and elapsed time get input on the log. This log is used by several people daily.
the formula i have at the moment is =IFERROR(INDEX(Inputs!$A$1:$L$3500,SMALL(IF(Inputs!$G$1:$G$3500='Cumulativetime'!$A$1,ROW(Inputs!$G$1:$G$3500)),ROW(Inputs!1:1)),12),"")
this formula works fine for daily time recording, but what i am looking to do is be able to have a dropdown in the cumulative time sheet (M1) for each person and have a formula that can generate the daily time for each person given a specified date in cumulativetime A1
i hope this makes sense
thanks in advance
