Date time issue

Hi

I have a spreadsheet where 1 column is date and time an order was entered the next column is the date and time the order was sent, the guy who created the spreadsheet then in the next column put the time difference between the 2 columns but this is where the issue is, for example the first cell is populated with 08/02/2006 03:37:18 (that is 2nd Aug 2006 the date is in US format) the 2nd cell is populated with 08/02/2006 04:09:35 so the time difference between these 2 times is 32 mins 17 secs, now he has the time difference as 0.54 which is obvioulsy in hours I want the time to show as 32 mins 17 secs ...........how can I convert the 0.54 into 32 mins 17 secs

Thanks for any help, advice

thanks Dave, that works for orders that the difference is less than a day but I have thousands of orders that the difference in time is over a day, how do I then convert that into minutes ????

cheers

Why not just use =B1-A1 and format as [h]:mm:ss. then 1 day 3 hours, 26 minutes would be shown as

27:26:00

i.e. 27 hours and 26 minutes.

If that's no good then please give the format you would like to see for such a time difference