In order to convert time in hours:minutes:seconds.milliseconds (hh:mm:ss.00) in excel, simply set the cell format to “[ss].00″. This is a custom format.

Make sure that you have enough s’s to cover the number of seconds there will be. e.g if the format is [ss].00 and your data is 3 minutes, then although you have 180 seconds, this will only appear as 80.00. If the cell format is [sss].oo you will get 180.00

Took me an age to figure out without the use of muliplication!

Gadzooks.

Over and out!