Convert cummlative hh:mm:ss to minutes

[dtjd1993]

I have a report that lists the amount of time people are logged out of a call center for various reasons. The time is cummulative for the day. I would like to add up the cummulative times for each reason and person for a month but the format is hh:mm:ss. I need to convert this to minutes. For example someone may have been logged out for 1 hr, 28 minutes and 30 seconds. The cell shows 01:28:30. I would like to convert this to 88.5 minutes. I have 1000's of entries that need to be "summed" I am looking for a formula to do the conversion for me. Any ideas?

 

[STEMALO]

just the fact of writing my problem down was enough to get my answer...
I just need to take (A1-B1)*24 and have it formatted in numbers with 2 decimals.


thank you all for your inspiration.