Hi
Does enyone know how I can convert standard text 160:00 to time 160:00:00? The output format of reports I'm getting from an other program makes it difficult to work with the numbers in excel.
Hi
Does enyone know how I can convert standard text 160:00 to time 160:00:00? The output format of reports I'm getting from an other program makes it difficult to work with the numbers in excel.
format cell as custom [h]:mm:ss
Hi,
Try to use
Formula:Please Login or Register to view this content.
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
I dit that, but it din't change to the format i wanted. Not unless I double click the cell and press enter. But then I'd have to do the same thing in every cell... A lot of work with a very big report.
Thanx, but I need it to change format in the native cell.
Will you upload sample file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks