Hi all, I am really really new to this excel formula game, but I am stuck. I recently gave in a grievance letter at work because of pay discrepancies, now I have my clocking times. Now I want to know, my clocking times are in the format 2021/04/13 21:15. I am aware one can seperate the time from date and visa versa. The times are in list form, and I need to write a "month-to-month calander" which shows my clocking times on any given day, and also then calculates my hours, and a block where I enter my rate per hour and it calculates a before deductions amount. I generated a sheet that can calculate all this, but since the clocking times are in a list is there a way to get them into their respective days without having to drag them there individually like this moron has been doing?