Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I only see in the help Time(HH:MM:SS)
Anyone know how?
Try this:
h:mm:ss tt (if you want seconds)
h:mm tt (if you do not want seconds)
Try this:
h:mm:ss tt (if you want seconds)
h:mm tt (if you do not want seconds)
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