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