Exclude dates from range in Google Spreadsheets

Question

I am new to google spreadsheets and trying to exclude dates from the range in google spreadsheets as follows.

I have the following cells in the range (c2: c7):

9/9/2015 9:21:09

9/9/2015 17:50:24

10/10/2015 17:25:57

11/11/2015 17:07:00

4/13/2015 18:13:35

04/14/2015 17:00:58

I want to exclude all dates and select the following range in B2:

9:21:09

17:50:24

17:25:57

17:07:00

18:13:35

17:00:58

I tried to use the regexextract function, but could not succeed, can someone help, I mentioned this at the following link:

https://docs.google.com/spreadsheets/d/1tsmeLz_TZ_nm_1M40bzM7cKq9mU_FUeFxdsk0fnL6wo/edit#gid=0

Answer 1

to try:

=ArrayFormula(mod(C2:C7,1)) 

where C2: C7 is a range with a timestamp. Format the output column as TIME (via 123 button)

Answer 2

Use regex.

 /(two numbers):(two numbers):(two numbers)/ 

After pulling each of these parts from the dates, save them in an array and set them in column B. (He prefers to copy to a 2D array and then use Range.setValues() for speed).

Answer 3

It works:

 =TEXT(A1,"HH:MM:SS")