@jefferybrown

that works great the way it is setup.

We use military time here though so the code changes back when entering the value in B2 so I assume the code time needs typed as military to achieve this?


one weird thing though is the first 3 cells in column H are italicized then the rest a different format.

thank you