Using Hours, Minutes and Seconds in excel

[Fish123]

Hi, I've got some lists of times in hours minutes and seconds for programme transcripts starting at a random number, for example one of my lists starts at 22 minutes and 30 seconds and then will have different time codes randomly for between 25 and 45 minutes. I need to minus the first value so that all of the times start at 00.00.00. I cant figure out how to do this, have tried a few different ways but keep on getting lost!
Any ideas? Might be something really simple that I'm not thinking of?
thanks

 

[sijpie]

Not very clear what you are trying to explain.

if one of the lists was
A
20:30
22:04
24:56
23:02

would your requirement be then that (say in the column next to it) it would read:
B
00:00
01:34
04:26
02:32
?

In that case the formula in B2 should just be:
A2-A$1
and copy that down

then if the format is funny format the cells as time

 

[Fish123]

Hi, thanks for replying on this. This works until I hit one hour, and then it doesnt work anymore. I had it as X.XX.XX and then used the Right(cell,5) formula to get rid of the hour and added 60 minutes and tried the formula but it doesn't work. You end up getting times like 27.88 for instance, which cant be valid?
Any other ideas would be much appreciated!

 

[barry houdini]

If you have . instead of : in the times then those aren't valid time values. You can use sijpie's suggestion with an inbuilt conversion. i.e. use this formula in B2

=SUBSTITUTE(A2,".",":")-SUBSTITUTE(A$1,".",":")

custom format B2 as [h]:mm:ss and copy formula down the column

 

[Fish123]

Perfect, thanks so much for both of your help