Hi, I am looking for some asisstance in regards to the following calculations that im working on.

I currently run the following formula in C2:

(Vol * Time)/86400

which converts the results into a time format, the problem i am having is that when i have done this for 200 cells, i then copy and repaste the results as values but some results show with a date in front of the time and some dont and also these dates vary. (the following are some of the results i am getting)

00/01/1900 00:16:48
01/01/1900 16:57:56
00/01/1900 21:32:00
00/01/1900 08:24:20
26/08/1900 07:01:24
02/01/1900 20:20:06

So my question is, how can i fix the cells to stay as just hh:mm:ss without the date in front, as i have also tried to run the text to columns function to separate the date and time, but what this does is that if that dates vary it adds an extra 24 hours to the time, which does not give me the correct result.

If somebody could please help, would really appreciate it, thanks in advance.