The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Hot answers tagged

2

SharePoint doesn't have parsing functions to automatically convert text to times. I'd recommend using a datetime field anyway, as that prevents data entry issues as well as makes the time calculation much simpler. If you must allow users to enter text, a developer could add an event handler or implement an Azure function to parse the string and perform the ...


2

Check Shifts functionality on Teams to have a whole tool for this stuff. This is the Microsoft bet inside the Office 365 suite for first line workers shift management.


1

Using the following forumla: INT(([Tech Checkout]-[Tech Checkin])*24)&":"&MOD(INT(([Tech Checkout]-[Tech Checkin])*1440),60) Result: Tech Checkin and Tech Checkout are single line of text fields Calculated Field Formulas Calculated Field Formulas with demos Note: If the answer helps you, don't forget to accept it as the best answer. It will help ...


1

This is not possible by OOTB. But there are many possible ways to achieve it. Along with the link shared by @ganesh in the comment above, you can try these couple of ways mentioned below: Using Date & Time field and Calculated Column Create a Date & Time column and a Calculated column with the formula: =TEXT([Date column name],"hh:mm AM/PM") Use ...


Only top voted, non community-wiki answers of a minimum length are eligible