Working within SP, I have two columns Tech Checkin and Tech Checkout with a third column titled Visit Duration.
The tech checkin and check out columns will contain a time only and are set as single line of text (I do not want a date populated in that column). The Visit Duration column should take the checkin and checkout times and create a sum equal to duration.
For example, tech check in is 12:00 PM and tech checkout is 1:27 PM. I want the Visit Duration column to read 1:27.
Is there a way to do this?