time values

Hi, I have a column with values A1 = 1030; a2=1031; a3=1034; a4=1152; a5=1153; etc. These values represent time "1030" means 10.30 am; 1152 means 11.52 am, respectively. I want to find the difference between a1 and a2; a2 and a3; a3 and a4; etc in Column B However, when I put e.g. a4-a5, it...

I have a dataset of times entered (incorrectly) in the format "10:32am" that I need to convert to sortable, graph-able time values. The best I've come up with so far is manually breaking the string apart and building it back together as the correct format, but it's not registering as a time...

I need help determining if time in Column B2 falls between "After Hours" (not list on the excel document). I have a document with times listed in column B. I am attempted to input a formula in Column N that will automatically say "Yes" or "No" if the times in Column B fall between after hours...

Hi there, I have a database that is downloaded, however some of the time values are not correct: here is a sample: 0 7:37:26 PM 0 9:41:43 PM 0 9:50:13 PM 0 9:40:30 PM 0 9:42:45 PM 0 9:44:45 PM 0 9:45:15 PM 0 9:46:01 PM 0 9:47:01 PM 0 9:47:31 AM 0 9:49:31 PM 12:01:55 AM 04:51:55 PM...