Hi, sorry im a relative beginner here in comparison.
I have 2 columns of data column A has the date and column b has the time.
Unfortunately column A is only populated once per day where as column B populates multiple times (up to 50) in the day.
What I want is if column A is not blank then tell me if the data in Column B is >09:00:00 or not
Ultimately I want to count the number of times the first login of the day is >09:00:00 in a month
I feel like i should be able to figure this out but its got me stumped can someone assist?
TIA
I have 2 columns of data column A has the date and column b has the time.
Unfortunately column A is only populated once per day where as column B populates multiple times (up to 50) in the day.
What I want is if column A is not blank then tell me if the data in Column B is >09:00:00 or not
Ultimately I want to count the number of times the first login of the day is >09:00:00 in a month
I feel like i should be able to figure this out but its got me stumped can someone assist?
TIA