Quote:
|
Depending on your requirements, a few IF tests might be suitable or a lookup table might be required. Or it might not even be practical...
|
I have a login sheet and everyone has a number they use to login for the day. This number varies and is both letters and numbers. I don't know what other information is needed to create the formula. I need a time of day in cell H2 based on any value in A2. This formula will need to be copied down several rows as there is up to a few hundred that sign in daily.
Does this information help?