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.

[TABLE="width: 227"]
<tbody>[TR]
[TD]WDH-PRI-LD-1 (17)[/TD]
[TD] 0:00:13[/TD]
[/TR]
[TR]
[TD]WDH-PRI-LD-1 (22)[/TD]
[TD] 0:01:06[/TD]
[/TR]
[TR]
[TD]WDH-PRI-LD-1 (13)[/TD]
[TD] 0:01:42[/TD]
[/TR]
[TR]
[TD]WDH-PRI-LD-1 (22)[/TD]
[TD] 0:01:15[/TD]
[/TR]
[TR]
[TD]WDH-PRI-LD-1 (22)[/TD]
[TD] 0:01:39[/TD]
[/TR]
[TR]
[TD]WDH-PRI-LD-1 (19)[/TD]
[TD] 0:00:05[/TD]
[/TR]
</tbody>[/TABLE]

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.