time formats

  1. M

    Uneditable cell format

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

    Column with Time-only data (1899-12-30 ...) won't reformat

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

    Excel timing help please!!!

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

    Converting Text to Time Format

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

    calculating hours for time sheets

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

    Problem with graph time on y-axis, date on x-axis

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

    Custom Time Formats?

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top