Calculate Time Span in Power Automate

Question

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

thanks,

Answer 1

Hi @Hysore, Ken ,

Please note that Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power Automate forum over here:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

----------

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

Best regards,
Leon

Answer 2

@Hysore, Ken ,

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

Start Compose:

ticks(triggerBody()?['EventDate'])  

End Compose:

ticks(triggerBody()?['EndDate'])  

DifferenceAshours Compose:

div(div(mul(sub(outputs('End'),outputs('Start')),100),1000000000),3600)  

Result:

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

More information:

https://powerusers.microsoft.com/t5/Building-Power-Apps/how-to-get-difference-between-two-dates-in-flow/td-p/283186

---

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.