Calculate Time Span in Power Automate

Hysore, Ken 1 Reputation point

I have a SharePoint calendar where I'm entering events with a Start Date and Time and an End Date and Time. I want to take the Start and End and determine the number of hours between the two. I will then enter the number of hours into the event.

I know I need to work with the timespan and most likely get ticks in the formula, but struggling a bit with this one.

Any help would be appreciated.

The info is all being pulled from and entered into a SharePoint calendar and im doing the automation and formulas using power automate


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,599 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Leon Laude 85,651 Reputation points

    Hi @Hysore, Ken ,

    Please note that Power Automate is currently not supported in the Q&A forums, the supported products are listed over here

    You may ask the experts in the dedicated Power Automate forum over here:


    If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

    Best regards,

    0 comments No comments

  2. JoyZ 18,041 Reputation points

    @Hysore, Ken ,

    Please refer to following steps in Power Automate to calculate hours between Start Time and End Time:


    Start Compose:


    End Compose:


    DifferenceAshours Compose:




    Then you could use DifferenceAshours Compose to update columns in calendar list.

    More information:

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.