I would imagine that there must be an easy fix to this problem for Microsoft, as it certainly did work OK in at least one previous version of Excel. I now have a new computer with Excel 2010 in which I cannot input hh:mm:ss, I have to use Excel's decimal equivalent of whatever time I want (which usually runs to several decimal places) - it's highly inconvenient and a serIous backwards step for Excel! I'veĪlso now found that sometimes hh:mm:ss will be accepted. And whenever you wanted, you could later change the times by inputting a differtent different hh:mm:ss value. Where 24:00:00 = 1.0, and 00:00:00 = 0, and subsequently always show them (in the input boxes) as this. ![]() We were unable to recreate the chart as needed, in (Win) Office 2007 or 2010. I successfully recreated the work in Office for Mac 2011. The original work was done in pre-Windows 2010 Office (one or two versions back). Excel did however immediately convert them into its decimal time format, &0183 &32 I was asked to update some procedures for creating a chart in Excel. On my old laptop computer, after selecting the x axis of the chart, I could input times into the input boxes of "Axis Options", under "Format Axis", in hh:mm:ss format (eg, 08:30:00). This concerns x,y scatter charts in Excel, when the x-axis is formatted in time (h:mm usually).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |