I have a shapefile of crime reports that includes the time a call was received and the time officers arrived on scene. I want to create response times from the difference in these two values. I know QGIS has support for the difference between dates, but I need the difference between two times in hh:mm format. Is there a way to do this in QGIS specifically? I am running QGIS 2.0 standalone version.
You can try the hour() field calculator function with a nested age() function:
That should output the difference in hours. But you might have to re-create your input field as Date type and format them like
YYYY-MM-DDTHH:MM:SS if not already.
I'm not sure if you can use more nested Conversion functions like
second() in the above expression if field calculator in QGIS doesn't recognize the fields you input because they might be strings.