How do I convert time 20:20 to time 2020?
How do I convert time 20:20 to time 2020?
goto
Format
Custom
change HH:MM
to HHMM
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
THANK YOU, Wayne!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
you are welcome
Hi Wayne.
So I ran my Excel worksheet with one additional variable.Now, when I try to change the time format from HH:MM to HHMM nothing happens. Any idea about what might be causing this?
THANKS.
Then there is no time in the cell but text. Possibly this works
in B1 =text(--a1,hhmm)
Or use text to columns
can you post a sample of it not working
Yes. I would love to share my Excel sheet. How can I share it?
yellow banner at top explains how
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
etaf Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Attached is the Excel spreadsheet. So I want to change time format from HH:MM to HHMM, and date format from mm/dd/yyyy to yyyy/mm/dd.
THANKS.
those cells are not time, JUST text entered as HH:MM
If you do
DATA>
TEXT to Columns
then it will change the cells to a TIME format
and then format as HHMM
@etaf, see #7
It worked. THANK YOU!
you are welcome
@Vraag en antwoord
Missed that good shout
Can anyone please tell me what is the definition of of "integer external" and if the data in the attached sheet meets the definition?
THANKS.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks