For date, I decided to format the column to Date and enter the initial date and then increase it by sequential order. So I think I don't need to manually enter every date as they are in sequential numbers anyway. Wish I thought about this earlier. But for shift start and shift finish time it is random numbers so I have to manually enter it in every cell. Now how can I get "5:21 PM" if I enter just 521? I want PM for shift start column and AM for shift end column to be added at the end and then I want to be able to calculate the number of hours worked in another column so I guess it can't be formatted as text as it cannot calculate.