@jeffreybrown

I realized that I had specified the wrong location last night when at work but couldn't respond to let you know that.

I got the code to work but its changing the value entered into B2 to 12:00 am.

I need the value entered to stay the same.

any thoughts?

As I continue to mess with this method there are a few bugs in it. when I use a numerical number from the call-in log it changes that number to "12:00am" I can then format the column to "text or general" and it will change it back to the numerical value entered.

the other issue is that I need to protect this sheet so other users cant screw up the formulas and I'm getting an error when protecting the sheet. I tried unlocking the column H where time is being entered and there is still an error popping up even though it adds the time in column H