Hello,
I am working on a report that uses a lot of time data. Our reporting tool outputs seconds like this :50 The problem with this is when I paste this into excel, excel does not recognize this as a time or a valid number, only if the field goes over :59 -- then it shows up as 1:00 or one minute.
Here is my example:
excel.jpg
This is causing a problem for our charting because excel is not recognizing this in time. If I go through and add a 0 manually to make it 0:50 then excel will recognize it, however, there are over 2000 lines like this.
I have tried =TEXT(CELL,"0000") but this does not work and I have tried =CONCATENATE("0000",CELL) and neither of these methods work.
Is there a way to format these cells or is their a formula I can use to fix this?
Thanks for your help!
Bookmarks