Hi, another newbie here, I am having a difficult time formatting a column of total hours and minutes. Excel wants to convert it to a date and time. For Example: 106:13:21 shows up as 1/4/1900 10:13:21 AM.
I have 106:13:21 h/m/s of downtime for a machine and need to display it on a graph as such. I have other similar quantities of time in the column that must also go on the chart.
How do I format the cells to not convert the h/m/s into date/time?
Have you used the custom number format [h]:mm:ss
Post example of your data/chart
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks