SOLVED

Time Value in List Columns

Copper Contributor

Is it possible to use something like this in a list column:

 

8:00 AM - 4:00 PM 

 

without using a choice/text field column, but using some sort of time/date column or calculated column?

2 Replies
best response confirmed by ikoalosaurus (Copper Contributor)
Solution

@ikoalosaurusSharePoint does not provide a column of type "Timespan". To achieve this in the most semantic way you'd need two columns of type date (startdate / enddate). You could then use calculated column to calculate and format your time range. You can get some examples on working with date values in calculated columns from the article below: 

 

https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b...

 

Hope this helps!

 

@Paul Pascha 

 

Thank you Paul , it sure does! : )

1 best response

Accepted Solutions
best response confirmed by ikoalosaurus (Copper Contributor)
Solution

@ikoalosaurusSharePoint does not provide a column of type "Timespan". To achieve this in the most semantic way you'd need two columns of type date (startdate / enddate). You could then use calculated column to calculate and format your time range. You can get some examples on working with date values in calculated columns from the article below: 

 

https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b...

 

Hope this helps!

 

View solution in original post