function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mitsvikmitsvik 

DATE Sorting for 24 hour time

I am for a 24 hour period how many chats are  ABANDONED  and it percentage to total requested. The formula I used to create the time interval field on Request Time is (Time interval formula field).User-added image
 
TEXT(VALUE( MID( TEXT( RequestTime - 0.2085), 12, 2 ) )) + " " +
IF(VALUE( MID( TEXT( RequestTime - 0.2085), 15, 2 ) ) <= 29, ":00", ":30")
 
The times are like this User-added image
That give me the time, but its so weird that when I sort by ascending it’s still showing 5 pm below 23:00….
Jolly_BirdiJolly_Birdi
Hello @Smitha,

Convert this text value to numeric value, It will sort your problem while sorting.

Thanks,
Jolly Birdi