Based what I have read here, I'd suggest a different design:

You need a sheet with employees table, which contains at least 1 column which indicates employee uniquely (name, ID, whatever). Define this column as dynamic range, which you can use as source of data validation list anywhere you need it;

All worktime data entry is made in single table on separate sheet, with columns like
Employee, ShiftNo, StartTime, EndTime, Date, ...
StartTime and EndTime must be datetimes, Employee and ShiftNo columns are data validation lists, and Date column is calculated as date of StartTime;

Probably you need a table where start and end times (in time format) for every shift are determined too. Like
ShiftNo, StartTime, EndTime;

Based on those tables, you can create any number of report sheets (like DailyReport, MonthlyReport, etc.) where at top you can set report conditions, and below a report table is calculated based on your data entry table, and set conditions.
I suspect to get the result you wanted in this post, the report table will be the daily one, like
Employee, 01, 02, ..., 24, Total
, with report condition the date for which you want this report. The Employees are read from employees table. The values for hours columns are calculated from data entry table as time by sumifs based on employee StartTime and EndTime at report date, and converted to numbers (1 or fraction of it) by mutipling the sumifs result with 24.