Friday, August 30, 2013

Show only the time in your sharepoint column

I hate that SharePoint does not provide a time only column. So, what should one do if they have a form in which their users need to record the time only?

In my example, I had to use a time/date column, called "Departure time" in which users needed to provide the time in which they departed  a location. However, I did not need a date.

Problem:
In InfoPath, I could delete the date portion of the form and leave only the time field. However, when I went to  the list view I would still see a date with their recorded time proceeding.


To get around this I used the steps below:
  1. Created a calculated column called 'Recorded Departure Time'
  2. Inserted the following formula: =Text (Departure Time,"HH:MM:SS")
  3. Edited my view to only show only my 'Recorded Departure Time' and hide my original 'Departure time'
Please Note: This method will show in military time. However, if you don't mind military time; this is a great solution.

Source: http://social.technet.microsoft.com/Forums/sharepoint/en-US/c8035f07-8320-48b5-98d7-f48dde2eaf2f/sharepoint-2010-insert-only-time-in-list-column

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.