time formats

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...

Hello experts, I have a column of data that I imported from Excel into SQL Server. The Excel format was 6:45:00 PM. It was imported into the SQL table in the format 1899-12-30 18:45:00.000 Now, however, when I pasted the data back into Excel and try to format it as 24 hr time (16:45), Excel...

Hi, I am trying desperately to change the format of the time I have copied and pasted off a website to do some analysis. The time looks like 11:07 (11 mins, 07 sec), but when I paste it into excel it reads it as 11hours and 7 minutes. All the posts I have read can convert this time, but I...

I have data in excel with the following time format (07:03:56.903); however, some of the times are in text format (0710251) and only to seven digits. I am trying to convert the text to the same format as the above time "hh:mm:ss.000" thanks in advance for any suggestions <tbody> </tbody>

Hi, my apoligies from the start if this question has been asked a million times before.. I did search the archieves for quite some time.. but no result, althought the format [h]:mm is going to be helpful. I am trying to put together a time sheet.. first adding hours per day, then totaling.. I am...

I have created a graph in Excel 2003 with three columns of data that are the times that the top 3 peak KW occurs during a day. The y-axis of my graph is supposed to be the time in the format "00:00:00" and the x-axis is the day that these occur. For some reason, the y-axis of this graph is not...

Hey, I've been trying to create a work schedule and I am having trouble formatting it just the way that I want it. Basically, I am looking to put in the time with an AM or PM after it. The problem that I am having is that if the time is on the hour I want it to display as 4 PM and...