Change your "Received at" Reporting
It currently records it as something like "09/07/11 @ 11:37:11 AM" which is good for American audiences who will not ever sort their data in a spreadsheet by who responds the quickest. I would recommend changing it to "2011/09/07 1137:11 hrs" or for a pm time "2011/09/07 1437:11 hrs"
This now allows anyone to sort the date/time stamp with an excel spreadsheet in the correct way from the largest time amount, year, and descending appropriately to seconds. The 24 hour time stamp has to be used to eliminate the need for am/pm which a spreadsheet will not easily use.
If you can't change the date format (because many people will get confused by that) at least change the time format.
Hi Darren,
We made some changes to the way response dates and times are displayed. The new format (only slightly different) will now be recognized as a date by excel.
-
Hi Darren,
This is an interesting point. The majority of our users are in the US and are more familiar with AM/PM. Also, the majority of spreadsheet programs have settings to recognize AM/PM and adjust accordingly. That being said there is merit to the argument that 24 hr time is a simpler more applicable standard. I will add this to discussion at our next planning meeting.
Thank you for your input!
Steve