ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2019 Chart Time Format (https://www.excelbanter.com/charts-charting-excel/447014-excel-2019-chart-time-format.html)

JerryN

Excel 2019 Chart Time Format
 
In previous versions of Excel, my X axis which is elapsed time, could be
custom formatted by entering the min, max etc. in the direct time format of
00:00:00 (hh:mm:ss). I am now using Excel 2010. If I want to enter, for
example, the major division value of 1 hour, I can no longer enter 01:00:00.
I must calculate the decimal equivalent of 1/24 and enter that number. What
am I missing?



All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com