Share via

Using custom time in excel doesn't display on chart correctly

Anonymous
2018-03-26T17:45:09+00:00

I'm trying to display real time down to milliseconds and excel doesn't seem to want to recognize and handle it consistently.

I have tried to create a custom formatted value "hh:mm:ss.000" and i have data that is displayed correctly in the data table, at least in the table view. However, excel doesn't seem to actually see it in this format and i end up with two major problems.

  1. When i chart the data with the real clock time as the x-axis, the axis will not display the same value as in the data table. I've tried selecting the chart axis and formatting it as "same as source" and I've tried manually telling it to use the exact same custom format the data is displayed as. In both cases the wrong values or no value is displayed.

  1. The 2nd problem is in the data table itself. if i select the a cell in the clock time column, then select the data in the data entry bar at top of table, then leave the cell without editing anything I lose my millisecond decimals. Apparently excel is treating the data in the data entry bar as yet a 3rd format, it's not the format i made and it's not in the raw decimal format, it's in some truncated rounded AM/PM date time format. In this case, it's not just a display variance but an actual data value change.

I've sent an example of this to MS Office help and they have had no solution and recommend i try the community. Hopefully someone has run into this and found a workable solution.

Thanks

Microsoft 365 and Office
Microsoft 365 and Office
A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-02T20:50:41+00:00

    Hello Michael,

    It seems that your concern is more complex than what is typically answered here. That being said, I advise posting this issue to our Tech Community. We have IT Pros that can provide you with the most appropriate solution and the best advice on how to go about this concern. But, prior posting this concern, you have to click on the JOIN button and follow the on-screen instructions.

    Should you need further help with other concerns in the future, you're always welcome to post back.

    0 comments