SOLVED

Time only column in a SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2068946%22%20slang%3D%22en-US%22%3ETime%20only%20column%20in%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2068946%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20that%20tracks%20miles%20someone%20has%20done%20in%20an%20activity.%20I%20am%20looking%20to%20add%20a%20column%20that%20they%20can%20put%20in%20how%20long%20it%20takes%20them%20in%20hours%20and%20minutes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20it%20is%20a%20time%20columns%20but%20may%20be%20wrong%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJ%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2068946%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2069564%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20only%20column%20in%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2069564%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F896720%22%20target%3D%22_blank%22%3E%40Jbrines1969%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20%22Time%20only%22%20column%20in%20SharePoint.%20In%20SharePoint%20you%20can%20create%26nbsp%3B%3CSTRONG%3EDate%20and%20Time%3C%2FSTRONG%3E%20column%20which%20can%20help%20you%20to%20track%20both%20date%20and%20time%20of%20activity%20completion.%20Check%20how%20to%20create%20a%20column%20in%20below%20article%3A%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Create%20a%20column%20in%20a%20list%20or%20library%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-column-in-a-list-or-library-2b0361ae-1bd3-41a3-8329-269e5f81cfa2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20a%20column%20in%20a%20list%20or%20library%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20show%20the%20Time%20only%20in%20separate%20column%20then%20you%20can%20extract%20time%20part%20from%20date%20%26amp%3B%20time%20using%20calculated%20column%20and%20show%20it%20in%20list%20view.%20Check%20below%20link%20for%20more%20information%20on%20this%3A%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Time%20only%20Column%20in%20Custom%20List%22%20href%3D%22https%3A%2F%2Fsharepoint.stackexchange.com%2Fquestions%2F223299%2Ftime-only-column-in-custom-list%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ETime%20only%20Column%20in%20Custom%20List%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

 

I have a SharePoint list that tracks miles someone has done in an activity. I am looking to add a column that they can put in how long it takes them in hours and minutes.

 

I believe it is a time columns but may be wrong

 

Any ideas?

 

J

1 Reply
Best Response confirmed by Jbrines1969 (Occasional Contributor)
Solution

@Jbrines1969 

 

There is no "Time only" column in SharePoint. In SharePoint you can create Date and Time column which can help you to track both date and time of activity completion. Check how to create a column in below article:

Create a column in a list or library 

 

If you want to show the Time only in separate column then you can extract time part from date & time using calculated column and show it in list view. Check below link for more information on this:

Time only Column in Custom List 


Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.