Time Value in List Columns

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?

SharePoint Online

paulpascha
Jul 17, 2019
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-2b4e-45ce-b170-bf7ebf6988b3

Hope this helps!

paulpascha

Bronze Contributor

Jul 17, 2019

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-2b4e-45ce-b170-bf7ebf6988b3

Hope this helps!

ikoalosaurus

Copper Contributor

Jul 18, 2019

paulpascha

Thank you Paul , it sure does! : )

Forum Discussion

Time Value in List Columns

Resources