Hi noodles1984;

PS: what is a UDF()
User Defined Function.
If you enter "=Date(2010,1,1)" in a cell, it will display "1/1/2010" (or however you have the cell formatted. "Date()" is a built in function. You can create your own functions, and use them just like Excel's built in functions.

Can you help me going forward, where do i go from here??
If you want to keep your current workbook the same as it now, I believe that you would have to create a UDF for you "Shift" column. I don't think it would be hard to write, but I personally don't think that is your best long term solution. As time goes by, you will want to improve the workbook to handle more & more situations, and you will be stuck with a format that can be hard to work with.

I personally would recommend redesigning your workbook.
I would create 1 sheet that asks for starting and ending date & time. Then a 2nd sheet that showed your visual display of shifts. This would be harder (and take longer), but I believe that it's a better long term solution.