Share via


Duration Calculator (Independent Publisher) (Preview)

A comprehensive duration and time calculation connector supporting business days, time zones, payroll periods, project timelines, and advanced DST calculations for enterprise applications.

This connector is available in the following products and regions:

Service Class Regions
Copilot Studio Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Troy Taylor
URL https://www.troystaylor.com
Email troy@troystaylor.com
Connector Metadata
Publisher Troy Taylor
Website https://www.troystaylor.com
Privacy policy https://www.troystaylor.com
Categories Productivity

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Calculate age

Calculate precise age and duration between dates with multiple output formats including years, months, days, and total time units.

Calculate business days

Calculate the number of business days between two dates, excluding weekends and optional holidays.

Calculate cross time zone duration

Calculate duration between two date-times across different time zones, accounting for DST changes.

Calculate deadline

Calculate time remaining until a deadline with detailed breakdown and milestone tracking.

Calculate DST transition

Calculate specific daylight saving time transition dates and analyze their impact on durations.

Calculate global working hours

Calculate working hours across multiple time zones with regional holiday support and custom schedules.

Calculate optimal meeting times

Find optimal meeting times across multiple time zones with availability constraints and working hours.

Calculate payroll periods

Generate payroll periods for weekly, bi-weekly, semi-monthly, or monthly schedules with working day calculations.

Calculate project duration

Analyze project timelines with milestone tracking, critical path analysis, and project status calculations.

Calculate working hours

Track and calculate working hours with support for custom schedules, overtime rules, and break time calculations.

Convert time zones

Convert datetime between 25+ supported time zones with automatic DST detection and adjustment.

Get DST history

Retrieve historical daylight saving time transition data for analysis and compliance reporting.

Get time zone information

Retrieve comprehensive time zone information including DST rules, current offset, and regional details.

Validate DST calculations

Validate and analyze daylight saving time calculations for accuracy and compliance.

Calculate age

Calculate precise age and duration between dates with multiple output formats including years, months, days, and total time units.

Parameters

Name Key Required Type Description
Birth Date
birthDate True date-time

The birth date and time for age calculation.

As Of Date
asOfDate date-time

Calculate age as of this date. Defaults to current date if not provided.

Include Time
includeTime boolean

Whether to include time precision in age calculation.

Returns

Calculate business days

Calculate the number of business days between two dates, excluding weekends and optional holidays.

Parameters

Name Key Required Type Description
Start Date
startDate True string

The start date for business day calculation.

End Date
endDate True string

The end date for business day calculation.

Holiday Dates
holidays array of string

Optional list of holiday dates to exclude from business day calculation.

Include Start Date
includeStartDate boolean

Whether to include the start date in the calculation.

Returns

Calculate cross time zone duration

Calculate duration between two date-times across different time zones, accounting for DST changes.

Parameters

Name Key Required Type Description
Start Date Time
startDateTime True date-time

Start date and time in the start timezone.

startTimeZone
startTimeZone True string

IANA time zone identifier.

End Date Time
endDateTime True date-time

End date and time in the end timezone.

endTimeZone
endTimeZone True string

IANA time zone identifier.

Account For DST
accountForDst boolean

Whether to account for daylight saving time transitions.

Returns

Calculate deadline

Calculate time remaining until a deadline with detailed breakdown and milestone tracking.

Parameters

Name Key Required Type Description
Deadline Date
deadlineDate True date-time

The target deadline date and time.

Current Date
currentDate date-time

Current date for calculation. Defaults to now if not provided.

Include Weekends
includeWeekends boolean

Whether to include weekends in the calculation.

Holidays
holidays array of string

List of holiday dates to exclude from calculation.

Returns

Calculate DST transition

Calculate specific daylight saving time transition dates and analyze their impact on durations.

Parameters

Name Key Required Type Description
Time Zone
timeZone True string

Time zone to analyze for DST transitions (IANA timezone).

Year
year True integer

Year to analyze.

Include Rules
includeRules boolean

Whether to include transition rules.

Include Impact
includeImpact boolean

Whether to include impact analysis.

Returns

Calculate global working hours

Calculate working hours across multiple time zones with regional holiday support and custom schedules.

Parameters

Name Key Required Type Description
Start Date Time
startDateTime True date-time

Start date and time for calculation.

End Date Time
endDateTime True date-time

End date and time for calculation.

Time Zones
Time Zones string

IANA time zone identifier.

Start Time
startTime time

Daily start time (HH:mm format).

End Time
endTime time

Daily end time (HH:mm format).

Working Days
workingDays array of string

Working days of the week.

Include Holidays
includeHolidays boolean

Whether to account for regional holidays.

Returns

Calculate optimal meeting times

Find optimal meeting times across multiple time zones with availability constraints and working hours.

Parameters

Name Key Required Type Description
Participant Name
participantName string

Participant name.

Local Date Time
localDateTime date-time

Meeting time in participant's local time zone.

timeZone
timeZone string

IANA time zone identifier.

Is Within Working Hours
isWithinWorkingHours boolean

Whether time falls within working hours.

Conflict Level
conflictLevel string

Level of scheduling conflict.

Duration Minutes
durationMinutes True integer

Duration of the meeting in minutes.

Meeting Type
meetingType string

Type of meeting for optimal scheduling.

Meeting Priority
priority string

Priority level for meeting scheduling.

Start Date
startDate True string

Start date of the range.

End Date
endDate True string

End date of the range.

Start Time
startTime time

Daily start time (HH:mm format).

End Time
endTime time

Daily end time (HH:mm format).

Working Days
workingDays array of string

Working days of the week.

Start Time
startTime True date-time

Start time of the slot.

End Time
endTime True date-time

End time of the slot.

Description
description string

Description of the time slot.

Returns

Calculate payroll periods

Generate payroll periods for weekly, bi-weekly, semi-monthly, or monthly schedules with working day calculations.

Parameters

Name Key Required Type Description
Start Date
startDate True string

The start date for payroll period calculation.

End Date
endDate string

The end date for payroll period calculation. If not provided, calculates one period from start date.

Period Type
periodType True string

Type of payroll period to calculate.

Include Partial Periods
includePartialPeriods boolean

Whether to include partial periods at the beginning or end.

Returns

Calculate project duration

Analyze project timelines with milestone tracking, critical path analysis, and project status calculations.

Parameters

Name Key Required Type Description
Start Date
startDate True string

Project start date.

End Date
endDate True string

Project end date.

Project Status
projectStatus string

Current project status for duration calculations.

Milestone Name
name True string

Milestone name or title.

Milestone Date
date True string

Milestone target date.

Holiday Date
date True string

The date of the holiday.

Holiday Name
name string

Name of the holiday.

Holiday Type
type string

Category of holiday for classification.

Holiday Observance
observance string

How the holiday is observed.

Include Weekends
includeWeekends boolean

Whether to include weekends in project duration.

Output Format
outputFormat string

Preferred output format for duration calculations.

Working Hours Period
workingHoursPeriod string

Type of working hours period for calculations.

Returns

Calculate working hours

Track and calculate working hours with support for custom schedules, overtime rules, and break time calculations.

Parameters

Name Key Required Type Description
Start Date Time
startDateTime True date-time

The start date and time for working hours calculation.

End Date Time
endDateTime True date-time

The end date and time for working hours calculation.

Work Start Time
start string

Working day start time (e.g., '09:00').

Work End Time
end string

Working day end time (e.g., '17:00').

Overtime Rate
overtimeRate number

Overtime multiplier rate (e.g., 1.5 for time-and-a-half).

Break Hours
breakHours number

Daily break time in hours to subtract from working hours.

Returns

Convert time zones

Convert datetime between 25+ supported time zones with automatic DST detection and adjustment.

Parameters

Name Key Required Type Description
Date Time
dateTime True date-time

The date and time to convert.

fromTimeZone
fromTimeZone True string

IANA time zone identifier.

toTimeZone
toTimeZone True string

IANA time zone identifier.

Returns

Get DST history

Retrieve historical daylight saving time transition data for analysis and compliance reporting.

Parameters

Name Key Required Type Description
Time Zones
Time Zones string

IANA time zone identifier.

Start Year
startYear integer

Start year for history (default: 2000).

End Year
endYear integer

End year for history (default: current year).

Include Political Changes
includePoliticalChanges boolean

Whether to include political/legislative changes.

Returns

Get time zone information

Retrieve comprehensive time zone information including DST rules, current offset, and regional details.

Parameters

Name Key Required Type Description
Time Zones
Time Zones string

IANA time zone identifier.

Reference Date
referenceDate string

Reference date for time zone information.

Include History
includeHistory boolean

Whether to include historical DST information.

Returns

Validate DST calculations

Validate and analyze daylight saving time calculations for accuracy and compliance.

Parameters

Name Key Required Type Description
Calculation ID
calculationId True string

Unique identifier for the calculation.

Time Zone
timeZone True string

Time zone for the calculation (IANA timezone).

Start Date Time
startDateTime True date-time

Start date and time.

End Date Time
endDateTime True date-time

End date and time.

Total Days
totalDays integer

Total number of days.

Total Hours
totalHours integer

Total number of hours.

Total Minutes
totalMinutes integer

Total number of minutes.

Total Seconds
totalSeconds integer

Total number of seconds.

Years
years integer

Number of complete years.

Months
months integer

Additional months after complete years.

Days
days integer

Additional days after complete months.

Hours
hours integer

Additional hours after complete days.

Minutes
minutes integer

Additional minutes after complete hours.

Seconds
seconds integer

Additional seconds after complete minutes.

Validation Rules
validationRules array of string

Validation rules to apply.

Compliance Standard
complianceStandard string

Compliance standard to validate against.

Returns

Definitions

TimeZoneEnum

IANA time zone identifier.

IANA time zone identifier.

BusinessDaysResponse

Name Path Type Description
Start Date
startDate string

The start date used in calculation.

End Date
endDate string

The end date used in calculation.

Business Days
businessDays integer

Total number of business days between the dates.

Total Days
totalDays integer

Total calendar days between the dates.

Weekend Days
weekendDays integer

Number of weekend days excluded.

Holiday Days
holidayDays integer

Number of holiday days excluded.

Holidays in Range
holidaysInRange array of string

List of holidays that fell within the date range.

AgeCalculationResponse

Name Path Type Description
Birth Date
birthDate date-time

The birth date used in calculation.

Calculation Date
calculationDate date-time

The date age was calculated to.

Age in Years
ageYears integer

Age in complete years.

Additional Months
ageMonths integer

Additional months beyond complete years.

Additional Days
ageDays integer

Additional days beyond complete years and months.

Total Days
totalDays integer

Total age in days.

Total Hours
totalHours integer

Total age in hours.

Total Minutes
totalMinutes integer

Total age in minutes.

Formatted Age
formattedAge string

Human-readable formatted age string.

WorkingHoursResponse

Name Path Type Description
Start Date Time
startDateTime date-time

The start date and time used in calculation.

End Date Time
endDateTime date-time

The end date and time used in calculation.

Total Hours
totalHours number

Total working hours calculated.

Regular Hours
regularHours number

Regular working hours (non-overtime).

Overtime Hours
overtimeHours number

Overtime hours calculated.

Total Days
totalDays integer

Total calendar days in the period.

Working Days
workingDays integer

Total working days (excluding weekends).

TimeZoneConversionResponse

Name Path Type Description
Original Date Time
originalDateTime date-time

The original date and time provided.

Converted Date Time
convertedDateTime date-time

The converted date and time in target timezone.

From Time Zone
fromTimeZone string

Source time zone used.

To Time Zone
toTimeZone string

Target time zone used.

Offset Difference
offsetDifference string

Time difference between zones.

DST Active
isDstActive boolean

Whether daylight saving time is active.

ProjectDurationResponse

Name Path Type Description
Start Date
startDate string

Project start date.

End Date
endDate string

Project end date.

Total Calendar Days
totalCalendarDays integer

Total calendar days in project.

Total Business Days
totalBusinessDays integer

Total business days in project.

Project Status
projectStatus string

Current project status assessment.

Milestone Analysis
milestones array of MilestoneAnalysis

Analyzed milestone information.

criticalPath
criticalPath CriticalPath

MilestoneAnalysis

Name Path Type Description
Milestone Name
name string

Milestone name.

Milestone Date
date string

Milestone date.

Days From Start
daysFromStart integer

Days from project start to milestone.

Days To End
daysToEnd integer

Days from milestone to project end.

Percent Complete
percentComplete number

Percentage of project timeline completed at milestone.

Is Overdue
isOverdue boolean

Whether the milestone is overdue.

CriticalPath

Name Path Type Description
Has Critical Path
hasCriticalPath boolean

Whether critical milestones were identified.

Critical Milestones
criticalMilestones array of string

Names of critical milestones.

Recommended Focus
recommendedFocus string

Recommended focus area for project success.

DstValidationResponse

Name Path Type Description
Validation Results
validationResults array of DstValidationResult

Validation results for each calculation.

Overall Compliance
overallCompliance boolean

Whether all calculations pass validation.

Compliance Score
complianceScore number

Overall compliance score (0-100).

Recommendations
recommendations array of string

Recommendations for fixing validation issues.

DstValidationResult

Name Path Type Description
Calculation ID
calculationId string

Calculation identifier.

Is Valid
isValid boolean

Whether the calculation is valid.

actualResult
actualResult DurationBreakdown
Deviations
deviations array of ValidationDeviation

Deviations from expected results.

Compliance Issues
complianceIssues array of string

Compliance issues found.

ValidationDeviation

Name Path Type Description
Field
field string

Field with deviation.

Expected
expected string

Expected value.

Actual
actual string

Actual value.

Severity
severity string

Severity of the deviation.

TimeZoneInfoResponse

Name Path Type Description
Time Zone Details
timeZoneDetails array of TimeZoneDetail

Detailed information for each time zone.

Comparisons
comparisons array of TimeZoneComparison

Comparisons between time zones.

TimeZoneDetail

Name Path Type Description
Time Zone ID
timeZoneId string

Time zone identifier.

Display Name
displayName string

Human-readable time zone name.

Current Offset
currentOffset string

Current UTC offset.

Standard Offset
standardOffset string

Standard time UTC offset.

Is Daylight Saving
isDaylightSaving boolean

Whether currently in daylight saving time.

dstRules
dstRules DstRules
regionalInfo
regionalInfo RegionalInfo

DstRules

Name Path Type Description
Uses DST
usesDst boolean

Whether the time zone uses DST.

Spring Forward Rule
springForwardRule string

Rule for spring forward transition.

Fall Back Rule
fallBackRule string

Rule for fall back transition.

Next Transition
nextTransition date-time

Next DST transition date.

RegionalInfo

Name Path Type Description
Countries
countries array of string

Countries using this time zone.

Major Cities
majorCities array of string

Major cities in this time zone.

Political Status
politicalStatus string

Political status of DST adoption.

TimeZoneComparison

Name Path Type Description
Time Zone 1
timeZone1 string

First time zone.

Time Zone 2
timeZone2 string

Second time zone.

Offset Difference
offsetDifference string

Time difference between zones.

Same Seasonal Pattern
sameSeasonalPattern boolean

Whether zones follow same DST pattern.

DstTransitionResponse

Name Path Type Description
Time Zone
timeZone string

Time zone analyzed (IANA timezone).

Year
year integer

Year analyzed.

Transitions
transitions array of DstTransition

DST transitions for the year.

Total Transitions
totalTransitions integer

Total number of transitions.

impactAnalysis
impactAnalysis DstImpactAnalysis

DstImpactAnalysis

Name Path Type Description
Affected Hours
affectedHours integer

Total hours affected by transitions.

Business Impact
businessImpact string

Assessed business impact level.

Recommendations
recommendations array of string

Recommendations for handling transitions.

Critical Periods
criticalPeriods array of CriticalPeriod

Critical periods requiring attention.

CriticalPeriod

Name Path Type Description
Start Date Time
startDateTime date-time

Start of critical period.

End Date Time
endDateTime date-time

End of critical period.

Description
description string

Description of the critical period.

Severity
severity string

Severity level.

DstHistoryResponse

Name Path Type Description
Time Zone Histories
timeZoneHistories array of TimeZoneHistory

DST history for each time zone.

summary
summary DstHistorySummary

TimeZoneHistory

Name Path Type Description
Time Zone
timeZone string

Time zone identifier.

Historical Transitions
historicalTransitions array of HistoricalDstTransition

Historical DST transitions.

Total Transitions
totalTransitions integer

Total number of DST transitions recorded.

Policy Changes
policyChanges array of DstPolicyChange

DST policy changes over time.

HistoricalDstTransition

Name Path Type Description
Year
year integer

Year of the transition.

Transition Type
transitionType string

Type of DST transition.

Transition Date
transitionDate date-time

Date and time of transition.

Offset Change
offsetChange string

UTC offset change.

Rule Applied
ruleApplied string

DST rule that was applied.

DstPolicyChange

Name Path Type Description
Effective Date
effectiveDate string

Date when policy change took effect.

Change Description
changeDescription string

Description of the policy change.

Reason
reason string

Reason for the policy change.

Impact
impact string

Impact level of the change.

DstHistorySummary

Name Path Type Description
Total Time Zones
totalTimeZones integer

Total time zones analyzed.

Total Transitions
totalTransitions integer

Total transitions across all time zones.

Most Active Time Zone
mostActiveTimeZone string

Time zone with most DST changes.

Trends
trends array of string

Observed DST trends.

Global Patterns
globalPatterns array of string

Global DST adoption patterns.

ParticipantLocalTime

Name Path Type Description
Participant Name
participantName string

Participant name.

Local Date Time
localDateTime date-time

Meeting time in participant's local time zone.

timeZone
timeZone TimeZoneEnum

IANA time zone identifier.

Is Within Working Hours
isWithinWorkingHours boolean

Whether time falls within working hours.

Conflict Level
conflictLevel string

Level of scheduling conflict.

PayrollPeriodsResponse

Name Path Type Description
Period Type
periodType string

Type of payroll period calculated.

Total Periods
totalPeriods integer

Total number of payroll periods.

Complete Periods
completePeriods integer

Number of complete payroll periods.

Partial Periods
partialPeriods integer

Number of partial payroll periods.

Periods
periods array of PayrollPeriod

List of all payroll periods with details.

PayrollPeriod

Name Path Type Description
Period Number
periodNumber integer

Sequential number of the payroll period.

Start Date
startDate string

Start date of the payroll period.

End Date
endDate string

End date of the payroll period.

Working Days
workingDays integer

Number of working days in the period.

Is Partial
isPartial boolean

Whether this is a partial period.

DeadlineCalculationResponse

Name Path Type Description
Deadline Date
deadlineDate date-time

The target deadline date and time.

Current Date
currentDate date-time

Current date used for calculation.

timeRemaining
timeRemaining DurationBreakdown
Business Days Remaining
businessDaysRemaining integer

Number of business days remaining.

Is Past Due
isPastDue boolean

Whether the deadline has passed.

Critical Status
criticalStatus string

Status of the deadline timeline.

CrossTzDurationResponse

Name Path Type Description
Start Date Time UTC
startDateTimeUtc date-time

Start date and time converted to UTC.

End Date Time UTC
endDateTimeUtc date-time

End date and time converted to UTC.

duration
duration DurationBreakdown
DST Transitions
dstTransitions array of DstTransition

List of DST transitions that occurred during the period.

Start Offset
timeZoneOffset.startOffset string

UTC offset at start time.

End Offset
timeZoneOffset.endOffset string

UTC offset at end time.

GlobalWorkingHoursResponse

Name Path Type Description
Total Working Hours
totalWorkingHours double

Total working hours across all time zones.

Time Zone Results
timeZoneResults array of object

Working hours breakdown by time zone.

Time Zone
timeZoneResults.timeZone string

Time zone identifier.

Working Hours
timeZoneResults.workingHours double

Working hours in this time zone.

Business Days
timeZoneResults.businessDays integer

Number of business days.

Overlap Hours
overlapHours double

Hours when all time zones have overlapping working hours.

MeetingTimesResponse

Name Path Type Description
Optimal Times
optimalTimes array of object

List of optimal meeting times sorted by suitability.

Start Time
optimalTimes.startTime date-time

Meeting start time in UTC.

End Time
optimalTimes.endTime date-time

Meeting end time in UTC.

Suitability Score
optimalTimes.suitabilityScore double

Score indicating how suitable this time is (0-100).

Participant Times
optimalTimes.participantTimes array of ParticipantLocalTime

Local times for each participant.

Conflicts
optimalTimes.conflicts array of object

List of scheduling conflicts.

Participant ID
optimalTimes.conflicts.participantId string

ID of the participant with conflict.

Conflict Type
optimalTimes.conflicts.conflictType string

Type of scheduling conflict.

Conflict Level
optimalTimes.conflicts.severity string

Level of scheduling conflict.

Unique Time Zones
timeZoneAnalysis.uniqueTimeZones integer

Number of unique time zones.

Max Time Offset
timeZoneAnalysis.maxTimeOffset double

Maximum time difference between participants in hours.

DurationBreakdown

Name Path Type Description
Total Days
totalDays integer

Total number of days.

Total Hours
totalHours integer

Total number of hours.

Total Minutes
totalMinutes integer

Total number of minutes.

Total Seconds
totalSeconds integer

Total number of seconds.

Years
years integer

Number of complete years.

Months
months integer

Additional months after complete years.

Days
days integer

Additional days after complete months.

Hours
hours integer

Additional hours after complete days.

Minutes
minutes integer

Additional minutes after complete hours.

Seconds
seconds integer

Additional seconds after complete minutes.

DstTransition

Name Path Type Description
Transition Date
transitionDate date-time

Date and time when the DST transition occurs.

Time Zone
timeZone string

Time zone where the transition occurs.

Transition Type
transitionType string

Type of DST transition.

Offset Before
offsetBefore string

UTC offset before the transition (e.g., '-05:00').

Offset After
offsetAfter string

UTC offset after the transition (e.g., '-04:00').

Time Adjustment
timeAdjustment integer

Time adjustment in minutes (+60 for spring forward, -60 for fall back).