Forum Discussion

jensjakobsen1966's avatar
jensjakobsen1966
Copper Contributor
Jan 24, 2022

Format a column in lists to MM.SS,00

Hi   I want to use SharePoint to log sports activities for my swimcoaches.   They need a column where they can store values from test sessions, and the format should be: Minutes, Sesonds, Hundre...
Lists
RobElliott's avatar
RobElliott
Silver Contributor
Jan 24, 2022

jensjakobsen1966 there's no time-only column type in SharePoint so to keep things simple just do this with a single line of text column. Then you can have a Power Apps customised form to add in the numbers and combine them into the final time as shown on the attached video.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

jensjakobsen1966's avatar
jensjakobsen1966
Copper Contributor
Jan 24, 2022
Thanks RobElliott. How did you split the single line text input, into 3 input fields?
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jan 24, 2022

    jensjakobsen1966 I didn't split anything, they are just 3 text input fields and there are the 2 columns from the SharePoint list. I combined the values I typed into the field underneath and then used this value as the default for the TimeCompleted field which is what was saved to the list.

     

     

     

     

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • jensjakobsen1966's avatar
      jensjakobsen1966
      Copper Contributor
      Jan 24, 2022
      OK, thanks RobElliott, as far as I can see you did a very nice trick with some PowerApp Form Customization - how did you do that? I went to:
      Integrate > Power Apps > Customize Forms - but from then on I need a little help. Iknow how to build Power Apps, but a SharePoint lists customization is a first time for me

Resources