Minus Time with DAX

[gmazza76]

Good afternoon,

I have managed to split the below from a text field of data in to "StartTime" and "EndTime", but I am having issues gaining "Call_Length" as once midnight passes the calculation I am using the formula below doesn't realise it has past midnight and should reset from this point.

How would I work round this?

=FORMAT(All_NLCS_Data[EndTime]-All_NLCS_Data[StartTime],"HH:MM:SS")

Thanks

 

[gmazza76]

Alternatively would it be easier to just extract the date & time stamp from the filed again instead of just time?
If so how do I extract them both as 1 from the field below as I have only extracted them separately before?

thanks