InterviewDB Question

Working Hours Register Program - Level 2: Time Interval Merging and Overlap Detection

Question Details

Round 1 - Coding Problem You are given a list of employee work sessions as [employee_id, start_time, end_time] tuples. Extend your Level 1 implementation to support: get_overlapping_sessions(emp_id) — return all sessions for the employee that overlap with at least one other session of the same employee. get_total_hours(emp_id, date) — return total worked hours on a given date, merging any overlapping intervals before summing. Follow-ups How would you handle sessions spanning midnight (e.g., 23:0…

Full Details

🔒

Unlock all Codesignal questions

Full insider details, leaked discussions, and candidate experiences.

or every company, $100/year →

About This Question

This is a reported interview question from a codesignal interview.

It covers the following topics: Coding, Industry Coding Framework .