Hello
I have one question about calculating duration of flight.
for example, one flight take off on 30 Nov 2012 at 9 pm, arrive on 1st Dec 2012 at 2am.
-------------------------------------------------------------------
N°Flt | DepartureTime | ArriveTime
----------------------------------------------------------
00001 | 11/30/2012 21:00 | 12/01/2012 2:00
-------------------------------------------------------------------
I want a pivot table to display like that:
-------------------------------
| Nov | Dec |(hour)
-------------------------------
Duration | 3 | 2 |
------------------------------
Thanks a lot a lot!
Edited by sophieTaureau - 19 Dec 2012 at 4:25am