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
Author: Imbizile

Hour format not working [SOLVED]

[Copy link]

2

Topics

21

Posts

48

Integral

Member

Rank: 2

Integral
48
 Author| Post on 2-11-2017 13:07:18 | 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, 17 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 13:51:07 | 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, 19 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 16:04:00 | 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, 22 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 18:33:54 | 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

    1

    Topics

    131

    Posts

    319

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    319
    Post on 2-11-2017 18:45:03 | All posts



    Everything between    is text and will not be translated.
    It does not depend on the language of excel but the regionale settings of the computer.









    Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 20:07:35 | All posts



    Ok, so I guess I will have to tell them, they have to change T in the formulas to their translation of hour.
    Thanks for the answers
    Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 16:03: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, 24 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 18:48:58 | 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, 26 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 22:28:21 | 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, 28 views)
    Download














  • Reply Support Opposition

    Props Report

    2

    Topics

    21

    Posts

    48

    Integral

    Member

    Rank: 2

    Integral
    48
     Author| Post on 2-11-2017 23:53:57 | 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, 30 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-20-2017 10:08 , Processed in 0.166195 second(s), 17 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!