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

this is straight simple in excel and no need to do anything except applying the time format to the cell.

two easy steps:

1. put the formula: =B2-A2
2. simply apply the custom format "h:mm" to the cell.

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