I'm currently checking my hours for work, I have a basic spread sheet with date and shift times, e.g. 01/29/19, 14:00-18:00, 4 hours.

Basically im going back and trying to work out if the shift was on a weekday, during the night, on a weekend, or a public holiday (and even working out if one shift had x hours worked during the day and x during the night) and then recording the hours again.

I'm just wondering if anyone has a better method then my current manually checking a calender seeing what day and time of the shift was and then putting the hours into the correct category. Would be a huge time saver and also check that I'm recording the correct hours in the correct category.

Kind of a shot in the dark and not sure if there is an automated way to do this, so any help would be greatly appreciated (even if it is manually doing it is the only way). Please tell me if you need me to clarify anything.