topic VB or SQL for Time Rounding? in Data Management Questions https://community.esri.com/t5/data-management-questions/vb-or-sql-for-time-rounding/m-p/300526#M17215 <HTML><HEAD></HEAD><BODY><SPAN>Hello everyone,</SPAN><BR /><BR /><SPAN>I need a simple solution for rounding time to the nearest minute. I have two date fields (one represents a start time, the other a finish time both in HH:MM:SS) and I've calculated a duration field with (DateDiff ( "n", [STARTTIME], [FINISHTIME] ) which results in a single minute value. The target field is Float type and after the calculation one can see residual rounding issues (EG: 21:10 being rounded to 22).</SPAN><BR /><BR /><SPAN>Is there some code I can include with the above DateDiff calc (or even run as stand alone) that will round to the nearest minute? (under 30-down, 30 and over-up). Any help would be mucho appreciated. Thanks.</SPAN><BR /><BR /><SPAN>Larry</SPAN></BODY></HTML> Wed, 27 Feb 2013 11:48:10 GMT LarryGaudieri 2013-02-27T11:48:10Z VB or SQL for Time Rounding? https://community.esri.com/t5/data-management-questions/vb-or-sql-for-time-rounding/m-p/300526#M17215 <HTML><HEAD></HEAD><BODY><SPAN>Hello everyone,</SPAN><BR /><BR /><SPAN>I need a simple solution for rounding time to the nearest minute. I have two date fields (one represents a start time, the other a finish time both in HH:MM:SS) and I've calculated a duration field with (DateDiff ( "n", [STARTTIME], [FINISHTIME] ) which results in a single minute value. The target field is Float type and after the calculation one can see residual rounding issues (EG: 21:10 being rounded to 22).</SPAN><BR /><BR /><SPAN>Is there some code I can include with the above DateDiff calc (or even run as stand alone) that will round to the nearest minute? (under 30-down, 30 and over-up). Any help would be mucho appreciated. Thanks.</SPAN><BR /><BR /><SPAN>Larry</SPAN></BODY></HTML> Wed, 27 Feb 2013 11:48:10 GMT https://community.esri.com/t5/data-management-questions/vb-or-sql-for-time-rounding/m-p/300526#M17215 LarryGaudieri 2013-02-27T11:48:10Z