I created a simple query to calculate the "incident duration" from an incident start (hh:mm:ss) and end time (hh:mm:ss) into minutes.
In the query the expression I used was this...
"Incident Duration: [Incident End Time]-[Incident Start Time]*24*60"
The problem is I'm not getting the results i wanted. I'm getting the results it in dd/dd/dd/ hh:mm:ss format.
Example of results Im looking for.
If start time= 9:44:00 and end time= 23:00:00, result should be 796.00
or
If start time= 11:38:27 and end time= 11:41:30, result should be 3.05
Any ideas of what I can do?
In the query the expression I used was this...
"Incident Duration: [Incident End Time]-[Incident Start Time]*24*60"
The problem is I'm not getting the results i wanted. I'm getting the results it in dd/dd/dd/ hh:mm:ss format.
Example of results Im looking for.
If start time= 9:44:00 and end time= 23:00:00, result should be 796.00
or
If start time= 11:38:27 and end time= 11:41:30, result should be 3.05
Any ideas of what I can do?