You have a datasource whose column A contains date/time in unix format. You wish to display the date in the calendar format of MMM dd, yyyy but you also wish to include the hour and minute information (with a separator of :). How do you specify the time to match the requirement above?

✅  The correct answer is:

c and d

Question:

You have a datasource whose column A contains date/time in unix format. You wish to display the date in the calendar format of MMM dd, yyyy but you also wish to include the hour and minute information (with a separator of :). How do you specify the time to match the requirement above?

Solution:

  • HH:MM
  • hh:MM
  • hh:mm
  • HH:mm
  • c and d
  • None of the above