Formula help converting minutes

[TechUser23]

Perhaps I'm missing something obvious....

I have three data fields I'm trying to base three formula's on.

Data Fields:
{data.ArrivalTime}
{data.WithProvider}
{data.CompletedTime}

Formulas:
Wait Time: {data.WithProvider} - {data.ArrivalTime}
Provider Time: {data.CompletedTime} - {data.WithProvider}
Total Time: {data.CompletedTime} - {data.ArrivalTime}

When I enter my three formulas as I have my time is coming back as "0" .... ?? Did I miss something obvious? Can anyone assist me and see an issue? I right clicked on my formula fields and changed the formatted the field to -1123. Im lost and sure could use some help.

 

[lbass]

Are these fields of time datatype? Try using a formula like:

datediff("n", datetime(currentdate,{data.ArrivalTime}), datetime(currentdate,{data.CompletedTime}))

-LB