How to get the hour and minutes difference between 2 datetimestamp in Excel?

Question

Suppose I have 2 timestamp dates: - 2/24/2010 1:05:15 AM - 2/25/2010 4:05:17 AM Can anyone please advise what function should I use in Excel to get the difference in hours and minutes? Thanks.

Accepted Answer

The difference in hours:

```
=(A2-A1)*24
```

The difference in minutes:

```
=(A2-A1)*24*60
```

The difference in hours and minutes:

```
=TRUNC((A2-A1)*24)      - the hours portion
=MOD((A2-A1)*24*60,60)  - the minutes portion
```

How to get the hour and minutes difference between 2 datetimestamp in Excel?

Solution

Problem