none
Calculated List Column?? - Only Display Start/End Date and not Start/End Date with Start /EndTime RRS feed

  • Question

  • H

    I would like the following columns in my calendar list but am unsure how to display them in calculated columns:

    • Start Date e.g. 09/05/2012
    • Start Time e.g. 13:30
    • End Date e.g. 10/05/2012
    • End Time e.g. 14:29

    The reason being is the our company website calendar is updated by a CSV file which treats Date and Time as two seperate fields. Currently start is displayed in the list as 09/05/2012 19:00:00 what I want to do is to split this so addtional calulated columns Start Date would display 09/05/2012 and Start Time would display 19:00:00.

    If anyone could help me this would me much appreciated as I cant seem to find the correct calculated column formulas?

    Thanks

    Wednesday, May 9, 2012 5:58 PM

Answers

  • H

    I would like the following columns in my calendar list but am unsure how to display them in calculated columns:

    • <xmlns:texthelpns rwthpgen="1">Start Date e.g. </xmlns:texthelpns>09/05/2012
    =TEXT(Start,"dd/mm/yyyy")
    • Start Time e.g. 13:30
    =TEXT(Start,"hh:mm")
    • End Date e.g. 10/05/2012
    =TEXT(End,"dd/mm/yy")
    • End Time e.g. 14:29
    =TEXT(End,"hh:mm")

    <xmlns:texthelpns rwthpgen="1">The reason being is the our company website calendar is updated by a CSV file which treats Date and Time as two separate fields.</xmlns:texthelpns><xmlns:texthelpns rwthpgen="1">Currently start is displayed in the list as 09/05/2012 19:00:00 what I want to do is to split this so additional calculated columns Start Date would display 09/05/2012 and Start Time would display 19:00:00.</xmlns:texthelpns><xmlns:texthelpns rwthpgen="1"></xmlns:texthelpns>

    If anyone could help me this would me much appreciated as I cant seem to find the correct calculated column formulas?

    Thanks

    <xmlns:texthelpns rwthpgen="1">I managed to solve it, see quoted post above for formulas used.</xmlns:texthelpns><xmlns:texthelpns rwthpgen="1">Using Calculated columns and the data type Single line of text.</xmlns:texthelpns>


    • Marked as answer by Powerballer Wednesday, May 9, 2012 6:19 PM
    • Edited by Powerballer Wednesday, May 9, 2012 6:50 PM
    Wednesday, May 9, 2012 6:18 PM