Forum Discussion

Rnaval's avatar
Rnaval
Post Partisan
5 months ago
Solved

Format a Time Column

How do I change the time format from 

 

1:36:00 pm

 

to

 

1:36 pm

 

I'm sure this is easily done, I just can't seem to find the option, appreciate any help.

 

Thanks...Rohit

Need Help
  • MasonMA's avatar
    MasonMA
    5 months ago

    In Model view, select your time column, then under formatting select Custom, enter 'h:mm AM/PM' in Custom format. 

     

     

     

     

2 Replies

  • MasonMA's avatar
    MasonMA
    Super User
    5 months ago

    In Model view, select your time column, then under formatting select Custom, enter 'h:mm AM/PM' in Custom format. 

     

     

     

     

    • Rnaval's avatar
      Rnaval
      Post Partisan
      5 months ago

      Thank you, that worked. I actually found an option for time short format instead of time long format which is what was needed.