Difference between two time columns

[system]

Hi,

I have two columns for current week and last week displaying hours/minutes taken to respond to a ticket e.g. 02:13

Current Week = 02:13
Last Week = 02:23

WoW = Current Week - Last Week

When I try to create this formula is errors which invalid data type. Is there a way I can create this formula?

Below is the variable which creates the measures:

=If([Time Seconds (Response)]>86400) Then
[Time Days (Response)]+" "+
FormatNumber(Floor(Mod([Time Seconds (Response)];86400)/3600) ;"00") + ":" + 
FormatNumber(Floor(Mod(Mod([Time Seconds (Response)];86400) ;3600)/60) ;"00") 	
Else
FormatNumber(Floor([Time Seconds (Response)]/3600) ;"00") + ":" + 
FormatNumber(Floor(Mod([Time Seconds (Response)] ;3600)/60) ;"00") 

---

Ram56 (BOB member since 2019-02-05)

[system]

your current and last week are of type string.
convert it to type date/time and then use daysbetween() or timebetween()

something like that:

calculate difference between two times in webi

THIS May be the answer I have been looking for…or at least on the right track. I changed the names of the fields to match my fields. [Start Time] would replace [oldest time stamp] and [End Time] would replace [Newest Time Stamp]? Right? And if the time is labeled as a text column, how can I change it? It will not let me select any number options in the format cell menu. I have spent hours to get a duration, and finally found this forum, so I am really hoping you can help! THANK YOU!!! b…

---

n8aktiv (BOB member since 2018-12-29)