I exported a report from Crystal to Excel. The times came over as numbers. How do I convert the numbers into time.
Example: 753 to 7:53
1426 to 14:26
Thankyou
I exported a report from Crystal to Excel. The times came over as numbers. How do I convert the numbers into time.
Example: 753 to 7:53
1426 to 14:26
Thankyou
Hi
try =(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))+0 and format as h:mm
1 way
=--TEXT(A1,"00\:00")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I have tried both of the suggestions and I either get "value" in the box or "0:00". I feel I am overriding the existing # when I type the formula in. I feel stupid...
Both suggestions worked fine for me.
You need to copy the suggested forumla into a blank cell, it assumes that your data is in cell A1, you cannot copy the formula over the top of the data, it misy go into it's own cellI feel I am overriding the existing # when I type the formula in
Hope hat helps?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks