changing a list of numbers into a time format

I imported a list of times for a measured paramater that imported into excel as numbers and not a time format and I need to make this list back to a hourly and minute time format for analysis and plotting.

for example, my list of time looks like this:

15
30
45
100
115
130
145
200
215
2300
2330
2345
0


The first numbers like 15 = a time of 00:15 AM, when it gets to 100, that actually = 01:00 AM, the list goes onto 2345 which = 23:45 PM then back to 0 which is 12:00AM

is there a way to take this list of time that are not formatted as time in hours and minutes and make it so. I tried playing with Excel rime formatting and it didnt seem to work. Its a long list of numbers so I am hoping there is a way to make this work.

Thanks, Roger
http://www.excelforum.com/images/smilies/confused.gif

With your numbers starting in A1, put this formula in B1:

=TIME(INT(A1/100),MOD(A1,100),0)

Format the cell how you would like to see it, then copy down.

Hope this helps.

Pete