Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Chelsie Eiden's Duration

Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...
Other
Time Intelligence
Totals
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler  Hi Greg.  I cannot get this to work.  It shows the values as billions (or millions if I narrow the scope down).  Note: I only need it to show hours and minutes.

 

 

 
 

 

 

I have thoroughly examined Chelsie's file and can find no issue.  Can you help?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous So this happened in another thread dealing with this. I believe the fix was to go into the Values area of the visual and turn off auto display format and change it to None and then the custom format string worked as designed.

    • Patrick_AW's avatar
      Patrick_AW
      New Member
      4 years ago

      Greg_Deckler I have a similar issue as mentioned by Anonymous .

       

      But in my case I have succeded in turning off auto display format and changing it to None. The custom format string 00:00:00 worked as designed.

      I will like to display only hours and minutes eg. 12:34 and not 12:34:56.

      How do I go about this? Using 00:00 displays 1234:57

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        4 years ago

        Patrick_AW Try changing the last line to:

         

        Hours * 100 + Minutes

         Then try a custom format string like 0000:00 or 00:00