Uneditable cell format

[mistahmistah]

Hello,

I have a spreadsheet I export from our Telephony Company. The problem is I can not enable the time column (column B below) to be editable so that I can run a formula to segment time spans together. Please let me know if you are to get this column into a workable format. The format dropdown samples do not change when selected.

WDH-PRI-LD-1 (17)	0:00:13
WDH-PRI-LD-1 (22)	0:01:06
WDH-PRI-LD-1 (13)	0:01:42
WDH-PRI-LD-1 (22)	0:01:15
WDH-PRI-LD-1 (22)	0:01:39
WDH-PRI-LD-1 (19)	0:00:05

<tbody>
</tbody>

Thank you!

 

[RickXL]

Hi,

They might be stored as character strings and just look like times.

Try using, for example:
=TIMEVALUE(B1)
in another column to see if Excel can convert it to a real Excel time.