Answered

Calculation Time Duration Within Specific Time Period

(0) Share

Report

Posted on by nazmisyaz1

Hi Power Automate Community,

I need help to build a flow that will determine each sharepoint item time duration,
Given the start timing is the sharepoint item creation date and end timing is current time.
However, the Time Duration calculation must within specific time period as below:

Day	Time Period Start	Time Period End
Monday	8:00 AM	9:00 PM
Tuesday	11:00 AM	9:00 PM
Wednesday	3:00 PM	9:00 PM
Thursday	10:00 AM	9:00 PM
Friday	8:00 AM	9:00 PM
Saturday	N/A	N/A
Sunday	N/A	N/A

For Example, if the sharepoint item creation date is dated Tuesday (30 May 2023) at 9 AM and current time is Friday (2 June 2023) at 11 AM.

The Time Duration calculation should be like below:

Tue Duration = 9.00 PM - 11.00 AM
Wed Duration = 9.00 PM - 3.00 PM
Thu Duration = 9.00 PM - 10.00 AM
Fri Duration = 11 AM - 8.00 AM

Total Duration = Tue Duration + Wed Duration + Thu Duration + Fri Duration

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @nazmisyaz1

Duration needs to be calculated in hours or days ?

Also does date is not considered while calculating duration ?

Was this reply helpful? Yes No
nazmisyaz1 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar ,

The Duration will be in hours, and date is not considered actually, just the day as need to check the exact time period for different days

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @nazmisyaz1

Give a try with this expression to compute duration (in hours)

div(mul(sub(ticks(utcnow()),ticks(
items('Apply_to_each')?['Created']
)),100),3600000000000)

Hope this helps !

Was this reply helpful? Yes No
nazmisyaz1 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar ,

The expression given can calculate the duration between current time and start time only,
but I need the duration to comply below table time period.
For the timing outside of this table, will not calculated in the duration

Day Time Period Start Time Period End
Monday 8:00 AM 9:00 PM
Tuesday 11:00 AM 9:00 PM
Wednesday 3:00 PM 9:00 PM
Thursday 10:00 AM 9:00 PM
Friday 8:00 AM 9:00 PM
Saturday N/A N/A
Sunday N/A N/A

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @nazmisyaz1

One question may be i am confused

does the above table you have shared is list in sharepoint ?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @nazmisyaz1 ,

Please try:

1\

if( equals(dayOfWeek(variables('DateTamp')),1), div(sub( max(ticks(variables('DateTamp')),ticks(addHours(startOfDay(variables('DateTamp')),8))),min(ticks(utcNow()),ticks(addHours(startOfDay(variables('DateTamp')),21)))),36000000000), if( equals(dayOfWeek(variables('DateTamp')),2), div(sub( max(ticks(variables('DateTamp')),ticks(addHours(startOfDay(variables('DateTamp')),11))),min(ticks(utcNow()),ticks(addHours(startOfDay(variables('DateTamp')),21)))),36000000000), if( equals(dayOfWeek(variables('DateTamp')),3), div(sub( max(ticks(variables('DateTamp')),ticks(addHours(startOfDay(variables('DateTamp')),15))),min(ticks(utcNow()),ticks(addHours(startOfDay(variables('DateTamp')),21)))),36000000000), if( equals(dayOfWeek(variables('DateTamp')),4), div(sub( max(ticks(variables('DateTamp')),ticks(addHours(startOfDay(variables('DateTamp')),10))),min(ticks(utcNow()),ticks(addHours(startOfDay(variables('DateTamp')),21)))),36000000000), if( equals(dayOfWeek(variables('DateTamp')),5), div(sub( max(ticks(variables('DateTamp')),ticks(addHours(startOfDay(variables('DateTamp')),8))),min(ticks(utcNow()),ticks(addHours(startOfDay(variables('DateTamp')),21)))),36000000000), 0 ) ) ) ) )

2\

startOfDay(addDays(outputs('Compose'),1))

Result

Best Regards,

Bof

Was this reply helpful? Yes No
nazmisyaz1 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thank you for your support, let me try your flow first.

Was this reply helpful? Yes No
nazmisyaz1 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar ,

No its not in the sharepoint, its a time period condition

Was this reply helpful? Yes No