Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
Apr 04, 2023

Calculate and Display hh:mm:ss

As there is no 'Time' only format in SP (to my knowledge), does anyone have a suggestion of how I can calculate the 'WaitTime' of 'OutTime' (DateTime) minus 'InTime' (DateTime) and display the results in hh:mm:ss (00:00:00)?


Excel -

SharePoint

 

SharePoint Online

1 Reply

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Apr 04, 2023

    Phishdawg Use calculated column for WaitTime and use formula like: 

     

    =TEXT([OutTime]-[InTime], "hh:mm:ss")

     

    Please click Mark as Best Response & Like 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.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources