Calculating a duration in excel from date and time

Solution 1:

So for your example the number of minutes is 548? You can do a simple subtraction to get total hours/minutes, so if you have start time/date in A2 and end time/date in B2 this formula....

=B2-A2

with result cell formatted as [h]:mm will give you 9:08

to get 548 just multiply by 1440 (number of minutes in a day), i.e.

=(B2-A2)*1440

format result cell as general