shg - my mistake... my first line in the sheet as you can see is actually 0001 to 0100. Looking at the scratch.xlsx file you uploaded, you changed the data type in column E so it isn't text anymore. I need to keep the data type as text because that is how it is imported from Access (copy/paste actually). When I use the IsText() function on the data, I get a true. Once I change the data type to what you set (I actually did a copy/paste of your column E to mine and then my formula worked).

djapigo - I have stuck in the function to change the text to a value when taking the time out of column B but when I use the value function to change the text of the data, I get an Excel formula error. I have tried just using the value function when pulling the time out of column B and that didn't work.

It seems the key to this problem is the data type for the actual data that I take from the Access database.