Hello, would like some assistance with a time calculation. Need to calculate
the total hours spent for a time from where I have a day and time in Europe
as a start time, and a day and time in Asia as an end time, taking under
consideration that the end time is 7 hours ahead of the start time. Here are
my fields:
A1: Monday 9 (start day)
B2: 16:00 (start time in military time)
C1: Wednesday (end day in Asia)
D1: 9:00 (end time in military time, plus 7 hours ahead of the start time).

Goal: To calculate the total transit time in hours.

Does anyone know? Thank you.
Simon