Sorry only have minute
Suggest you check out Pearson's 'Times And Working Hours, Between Two
Dates'
http://cpearson.com/excel/datetime.htm#WorkHours
And others he has listed
http://cpearson.com/excel/topic.aspx
Cheers
Mark
On Jul 11, 12:50 pm, STS wrote:
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