Not your average time zone question.

[Cedric Wyckmans]

Hi all,

New on the forum and need some help:

I am trying to build a formula to showing the decimal total for time traveled between timezones, including if that zone is daylight saving or not.

So i have following as in the picture 2013-09-04_11-28-08.jpg

Any help would be welcome.

Thanks Cedric

[Norie]

Cedric

Can you upload a sample workbook?

[Cedric Wyckmans]

sample.xlsx

Hope this works, could not find a upload button.

[shg]

You have pure time in col D and date and time in col H. Why is that?

[shg]

With pure times in columns C and G,

	B	C	D	E	F	G	H	I	J	K
2	Depart				Arrive
3	Apt	Local	DS	GMTą	Apt	Local	DS	GMTą	TT
4	DFW	18:35	1	-6.00	LHR	9:35	0	0.00	8:00	J4: =G4-C4-(D4-E4-H4+I4)/24 + (G4-C4-(D4-E4-H4+I4)/24 <= 0)
5	DFW	7:30	1	-6.00	SJC	9:00	1	-8.00	3:30
6	DFW	10:30	0	-6.00	ICN	16:40	0	9.00	15:10

[Cedric Wyckmans]

Awsome, thanks, really appreciate it. Yes it all needed to be Pure T.

Best Cedric