LinkBack URL
About LinkBacks
This should work if your data is text or number and placed in A1:
=(LEFT(TEXT(A1,"000000"),2)&":"&MID(TEXT(A1,"000000"),3,2)&":"&RIGHT(TEXT(A1,"000000"),2))+0 and format as [h]:mm:ss
This should work if your data is text or number and placed in A1:
=(LEFT(TEXT(A1,"000000"),2)&":"&MID(TEXT(A1,"000000"),3,2)&":"&RIGHT(TEXT(A1,"000000"),2))+0 and format as [h]:mm:ss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks