Using the IF function

[Paulette]

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

 

[Fred Smith]

Do yourself a favor and put your times in separate cells. Then the number of
hours is simply:
=(a2-a1)*24

To incorporate time zones, you need to provide more information as to the
results you want.

Regards,
Fred