Hi Guys,
Long time reader and viewer, first time poster.
Just exported some data from software at work into excel.
It comes with a column that reads "Downtime" and it has all the times that each job takes. eg 2:31 is two hours and thirty one minutes.
There are some jobs that take over 80 hours and they come up as say 65:34 which is 65 hours and thirty four minutes.
Convert the "downtime" cells to [h]:mm and in a new column multiply by 24 to get the decimal, and change the format of the new column to decimal? eg 1:30 will become 1.5.
When I do this, I get #VALUE! come up.
When I manually delete one value in the "downtime" column, the #VALUE! dissapears and the decimal value appears. Theres around.... 7000 rows of data here...
Even though I've selected the entire column and converted to custom [h]:mm, it just keeps repeating the #VALUE! error.
I have wasted 3.5 hours of life over this lol.
Bookmarks