MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
123Next
Return Post new threads
View: 900|Reply: 21

Hour format not working [SOLVED]

[Copy link]

2

Topics

21

Posts

48

Integral

Member

Rank: 2

Integral
48
Post on 2-10-2017 17:05:43 | All posts |Read mode
Hi all
Im having a strange issue with the hour format. Instead of showing the actual hour numbers, it always just shows h and hh. As shown in below screnshot, where I downloaded the TEXT function examples.xlsx from the online excel help.



I really hope someone have the solution for this
Im using MS Office 2013.
Thanks in advance
Best regards
Imbizile




Reply

Props Report

63

Topics

2079

Posts

4419

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4419
Post on 2-10-2017 17:26:12 | All posts



What is the URL for the download ?
Please post a copy of YOUR workbook here that is showing the issue. Remove sensitive data.











Reply Support Opposition

Props Report

2

Topics

21

Posts

48

Integral

Member

Rank: 2

Integral
48
 Author| Post on 2-10-2017 17:56:32 | All posts



I cant really save the url, cause a download window pops up and it dissapears when I close the pop up, but this is a picture of the url:


I attached the ms example file here though.
If you go to the Hours, minutes, seconds sheet you will notice that it shows hours on your end, instead of h and hh as shown in my first screenshot.








  • TEXT function examples.xlsx
    (170.5 KB, 5 views)
    Download














  • Reply Support Opposition

    Props Report

    1

    Topics

    131

    Posts

    319

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    319
    Post on 2-10-2017 18:24:46 | All posts



    You are coming from Denmark.
    Try T (Timer) instead of H (Hour)












    Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-10-2017 19:28:00 | All posts



    Yes popipipo, you seem to have hit the hammer on the nail. Thank you very much
    I just dont get why it does not translate Hours as the only thing. It translates everything else between english and danish formulas, like TEXT to TEKST etc and i usually dont have any trouble sharing excel files with people using excel in different countries.
    I gave you rep and will mark the thread as solved, but have an additional question though. Does this mean that they (people using different language excel) will have to change the formula from T to H when the open file on their end?
    Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-10-2017 23:37:38 | All posts



    I cant really save the url, cause a download window pops up and it dissapears when I close the pop up, but this is a picture of the url:


    I attached the ms example file here though.
    If you go to the Hours, minutes, seconds sheet you will notice that it shows hours on your end, instead of h and hh as shown in my first screenshot.








  • TEXT function examples.xlsx
    (170.5 KB, 7 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 00:56:43 | All posts



    I cant really save the url, cause a download window pops up and it dissapears when I close the pop up, but this is a picture of the url:


    I attached the ms example file here though.
    If you go to the Hours, minutes, seconds sheet you will notice that it shows hours on your end, instead of h and hh as shown in my first screenshot.








  • TEXT function examples.xlsx
    (170.5 KB, 9 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 02:34:04 | All posts



    I cant really save the url, cause a download window pops up and it dissapears when I close the pop up, but this is a picture of the url:


    I attached the ms example file here though.
    If you go to the Hours, minutes, seconds sheet you will notice that it shows hours on your end, instead of h and hh as shown in my first screenshot.








  • TEXT function examples.xlsx
    (170.5 KB, 11 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 06:44:09 | All posts



    I cant really save the url, cause a download window pops up and it dissapears when I close the pop up, but this is a picture of the url:


    I attached the ms example file here though.
    If you go to the Hours, minutes, seconds sheet you will notice that it shows hours on your end, instead of h and hh as shown in my first screenshot.








  • TEXT function examples.xlsx
    (170.5 KB, 13 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 07:46:05 | All posts



    I cant really save the url, cause a download window pops up and it dissapears when I close the pop up, but this is a picture of the url:


    I attached the ms example file here though.
    If you go to the Hours, minutes, seconds sheet you will notice that it shows hours on your end, instead of h and hh as shown in my first screenshot.








  • TEXT function examples.xlsx
    (170.5 KB, 15 views)
    Download














  • Reply Support Opposition

    Props Report

    123Next
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-18-2017 09:02 , Processed in 0.234825 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!