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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top