Hi all,

I need your help here.

We have workers working from 8:30:01 am to 8:30:00 pm for day shift and 8:30:01 pm to 8:30:00 am for night shift.

Checked the web and only have from 8am to 8pm.

How can I get the excel to show day and night shift?

Thanks in advance.