How can I calculate time worked for different time zones from 1 cell entry
e.g.

06:00 to 14:00 time worked (cell entry)

07:00-14:59 15:00-22:59 23:00-06:59 (time zones)

7 0 1
(time worked/time zone)

Can Excell help to compute the time worked using a formula?

Thanks