Calculate minutes in different time zones

[Aladino]

Hi there!

From 0:00 to 7:00 time zone A
From 7:01 to 15:00 time zone B
From 15:01 to 18:00 time zone C
From 18:01 to 0:00 time zone D

If Start time is 10:15 and End Time is 17:25, how can I calculate how
many minutes I´ve used from each time zone. Notice it can be on the
same day or in different days.

Thanks

 

[Bernard Liengme]

=B1-A1+(B1<A1)
The second terms add 1 (ie 24 hours) if midnight occurs during the interval
Will work if less than 24 hours in the interval
best wishes

 

[Alexander Wolff]

Hi there!

From 0:00 to 7:00 time zone A
From 7:01 to 15:00 time zone B
From 15:01 to 18:00 time zone C
From 18:01 to 0:00 time zone D

If Start time is 10:15 and End Time is 17:25, how can I calculate how
many minutes I´ve used from each time zone. Notice it can be on the
same day or in different days.

http://xxcl.de/5020.htm shows it for consecutive zones (if you need some
German translation, just let me know).

In the case of start day 1 zone C and arrival day 3 zone A (summing up the
same-zone times), it needs a sophisticated array formula.