I have a simple record in table below:

```
Depart_dt                    Arrived_dt
10/1/2013 6:15:00 AM         10/1/2013 7:25:00 AM    

```

Based on my calculation, it is 1 hour and 10 min.
Thanks to VKP, I used the datediff function as below:

```
Select 
Dateiff (DD, depart_dt, arrived_dt) as day,
Dateiff (HH, depart_dt, arrived_dt) as hour,
Dateiff (Minute, depart_dt, arrived_dt) as min,
Date if (second, depart_dt, arrived_dt) as second 
from temp

```

However, my result looks funny with the minute and second columns

```
Day   Hour   Min   Second 
0     1      70    4200

```

The hour appears correct but I am not sure how it comes to 70 in min column and 4200 in second column?

sorry guys, I was wrong. Yes, 70 min is correct because that is 1 hour and 10 min. Please disregard this