
Creator II
2011-08-24
01:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Time format including AM/PM
I only see in the help Time(HH:MM:SS)
Anyone know how?
18,272 Views
1 Solution
Accepted Solutions

Not applicable
2011-08-24
03:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
h:mm:ss tt (if you want seconds)
h:mm tt (if you do not want seconds)
2 Replies

Not applicable
2011-08-24
03:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
h:mm:ss tt (if you want seconds)
h:mm tt (if you do not want seconds)


Master
2011-08-24
08:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I have two solution:
1. On Chart
Right Click on Chart --> Properites --> Select Number tab --> Select on Expression --> Check on Time for number formate setting.
2. Use function:
TIME(TimeField,'h:mm:ss TT')
Regards,
Sokkorn
