Using the IF function

P

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top