Question Re: Calculating Time Interval between Two Time Feilds in Technology Q&A

Calculating Time Interval between Two Time Feilds

D_Yadav1 — Wed, 19 Mar 2025 17:47:08 GMT

#TimeInterval

Hi All,
I have requirement to calculate the time interval between two Time Feilds in Graphical View using Calculated Column
There are 4 Dimension for a requirement with data in below format. I need to calculate time interval between Process Order Start Time and Finish Time in Hours. I have tried various function but it's not giving accurate results. Can anyone help me to calculate the expected results.

Process Order Actual Start Date	Process Order Actual Finish Date	Process Order Actual Start Time (HHMISS)	Process Order Actual Finish Time (HHMISS)	Time Interval between Process Order Start Time and Finish Time in hrs (Expected Result)
20250106	20250107	164144	000000	8
20250107	20250122	063933	000000	18
20250117	20250117	000000	093135	9

Re: Calculating Time Interval between Two Time Feilds

Simon_Ye — Thu, 20 Mar 2025 06:18:48 GMT

You need to concatenate The Date and Time column to generate a timestamp, then calculate the interval:

Formula of the calculate column "IntervalDays": : DAYS_BETWEEN(TO_TIMESTAMP(CONCAT(START_DATE,START_TIME),'YYYYMMDDHHMISS'),TO_TIMESTAMP(CONCAT(END_DATE,END_TIME),'YYYYMMDDHHMISS'))

Re: Calculating Time Interval between Two Time Feilds

D_Yadav1 — Thu, 20 Mar 2025 06:36:27 GMT

Thanks for Response Simon. I need to calculate only hours between two time feilds Process Order Actual Start Time and Process Order Actual Finish Time. Date field is not involve in calculation.

Re: Calculating Time Interval between Two Time Feilds

Simon_Ye — Thu, 20 Mar 2025 08:03:16 GMT

First, you have to involve the Date because start and end date might be different and DSP doesn't support Time type. second, you can replcae the function DAYS_BETWEEN with SECONDS_BETWEEN to get the seconds, then convert the seconds to hours you want