Thanks everyone, and yes they have achieved a result similiar to what I'm after.
However, your solutions still require hard coding of the time codes. What I specifically want is for the function to determine which time codes it needs to include at runtime... Ie whichever time codes are associated with AM or PM.
The vlookup() function might be what I'm after but I cant get it to work!
Does that make sense? Thanks for all of your suggestions so far! Please keep them coming!
Bookmarks