You're going to have to provide a lot more detail than that. For example:
What text in A2
What times in H2 for the A2 values.
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...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|