Newguy1924
New Member
- Joined
- Apr 13, 2021
- Messages
- 13
- Office Version
- 2013
- Platform
- Windows
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?