Calculating Time Duration in Omniscope

In many business scenarios it is necessary to measure the length of time taken for activities or processes. This could be for operational efficiency, performance monitoring, or reporting purposes. Omniscope provides simple methods to calculate and convert durations so they can be analysed in minutes, seconds, hours, or milliseconds, depending on the requirement.

Use case examples:

• Time spent on a job
  
• Duration of customer service calls
  
• Processing duration
  
• Call waiting times
  
• Support ticket completion time

1. Using Time Duration Unit Converter Block 

This Python-based custom block can calculate durations with full flexibility for different time formats and units. It takes as input a duration field formatted as HH:mm:ss and outputs the total duration in the chosen unit.

2. Using a Formula for HH:mm:ss Format Durations

When the duration is formatted as HH:mm:ss, another method is to use a formula to convert the time into hours, minutes, seconds, or milliseconds. This allows the user to calculate the total time or the average time spent per call, job, etc.

Example formula to calculate minutes:

DATEDIFF(

TEXTTODATE("00:00:00", "HH:mm:ss"), 

TEXTTODATE([Duration text], "HH:mm:ss"), 

“minute")

Demo file is attached.