Uneditable cell format

mistahmistah

New Member
Joined
May 8, 2014
Messages
21
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!
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

RickXL

MrExcel MVP
Joined
Sep 9, 2013
Messages
4,314
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,918
Messages
5,525,624
Members
409,657
Latest member
19JimRon72

This Week's Hot Topics

Top