{"id":5458,"date":"2012-10-23T17:10:16","date_gmt":"2012-10-23T17:10:16","guid":{"rendered":"https:\/\/www.snapsurveys.com\/support-snap11\/?page_id=5458"},"modified":"2018-10-04T14:45:03","modified_gmt":"2018-10-04T13:45:03","slug":"calculating-difference-times-dates","status":"publish","type":"page","link":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/","title":{"rendered":"Calculating the difference between times on different dates"},"content":{"rendered":"<p>Previous worksheets showed how to calculate the difference between <a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-number-days-dates\/\" target=\"_parent\">different dates<\/a> and <a href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-time-minutes-time-variables\/\" target=\"_parent\">different times<\/a>. This worksheet expands on those by showing you how to calculate the difference (in hours) between different times on different dates. This could tell you how long someone had spent travelling etc.<\/p>\n<p>You can then use this information directly in analyses, or use a further derived variable to break it down into ranges defined by time intervals (for example, short trip, medium trip, and long waits).<\/p>\n<p><a name=\"o22587\"><\/a><\/p>\n<h3>Background<\/h3>\n<p>Snap stores date and time data in a format that you can use to make calculations. If you tell Snap that responses are a date or a time, Snap will use special calculations to work out the differences between them. The differences between dates are given in days, and the differences in times are given in seconds.<\/p>\n<p>This example uses a journey starting at 9pm on Monday 1st and ending at 10am on Thursday 4th, and shows how to calculate the journey length.<\/p>\n<p>By using two different types of derived variable, you can present the same data in quantitive and qualititive form, allowing for different types of analyses.<\/p>\n<p><a name=\"o22588\"><\/a><\/p>\n<h3>Summary of steps<\/h3>\n<p><a id=\"h22598\" title=\"Step 1: Creating the time and date questions\" href=\"#o22589\" target=\"_self\">Step 1: Creating the time and date questions<\/a><br \/>\n<a id=\"h22622\" title=\"Step 2: Changing the names of your variables for ease of calculation\" href=\"#o22614\" target=\"_self\">Step 2: Changing the names of your variables for ease of calculation<\/a><br \/>\n<a id=\"h22599\" title=\"Step 3: Creating the derived variable to calculate the difference\" href=\"#o22593\" target=\"_self\">Step 3: Creating the derived variable to calculate the difference<\/a><br \/>\n<a id=\"h22600\" title=\"Step 4: Splitting up the data into bands for analysis\" href=\"#o22595\" target=\"_self\">Step 4: Splitting up the data into bands for analysis<\/a><br \/>\n<a id=\"h22623\" title=\"Changing the variable names back to question numbers\" href=\"#o22620\" target=\"_self\">Changing the variable names back to question numbers<\/a><\/p>\n<div>\n<h3><a name=\"o22589\"><\/a>Step 1: Creating the time and date questions<\/h3>\n<ol>\n<li>Open your questionnaire. This assumes that you are asking about someone&#8217;s journey to a holiday destination.<\/li>\n<li>Enter the start date question.\n<ul>\n<li>Create a question by clicking <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17366\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/11\/add.png\" alt=\"add\" width=\"15\" height=\"16\" \/>\u00a0on the toolbar<\/li>\n<li>Set the style to <strong>Open First.<\/strong><\/li>\n<li>Set the response type to <strong>Date<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23817\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/resp_date.png\" alt=\"Response shown as Date\" width=\"498\" height=\"52\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/resp_date.png 498w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/resp_date-150x16.png 150w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/li>\n<li>Enter the question text &#8220;Please enter the date and time that you left home&#8221;.<\/li>\n<li>Enter the grid label text &#8220;Date of leaving&#8221;.<\/li>\n<\/ul>\n<\/li>\n<li>Enter the start time question\n<ul>\n<li>Press the [Enter] key to create a new question.<\/li>\n<li>Set the style to <strong>Open Next<\/strong>.<\/li>\n<li>Set the response type to <strong>Time<\/strong>.<\/li>\n<li>Enter the grid label text &#8220;Time of leaving&#8221;.<\/li>\n<\/ul>\n<\/li>\n<li>Repeat for the arrival date and time questions, changing the text as appropriate.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23811\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/date_time_quest.png\" alt=\"CD: date and time questions\" width=\"477\" height=\"313\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/date_time_quest.png 477w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/date_time_quest-150x98.png 150w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/li>\n<\/ol>\n<\/div>\n<div>\n<h3><a name=\"o22614\"><\/a>Step 2: Changing the names of your variables for ease of calculation<\/h3>\n<p>The variables you have created will have the question numbers by default. Since we are going to use them in a formula, it is easier to give them a name that explains what they are for.<\/p>\n<ol>\n<li>Right-click on your question asking for the &#8220;Date of leaving&#8221;, and select Variable properties from the context menu.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23816\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/quest_var_prop_datea.png\" alt=\"Variables properties with Name dateA\" width=\"286\" height=\"374\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/quest_var_prop_datea.png 286w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/quest_var_prop_datea-150x196.png 150w\" sizes=\"auto, (max-width: 286px) 100vw, 286px\" \/><\/li>\n<li>Edit the name of the variable to <strong>DateA <\/strong>and click <strong>[OK]<\/strong>.<\/li>\n<li>Change the variable name for the time of leaving to <strong>TimeA<\/strong> in the same way.<\/li>\n<li>Change the names of the arrival dates and times to <strong>DateB <\/strong>and <strong>TimeB<\/strong>.<\/li>\n<\/ol>\n<\/div>\n<div>\n<h3><a name=\"o22593\"><\/a>Step 3: Creating the derived variable to calculate the difference<\/h3>\n<p>You must now set up a derived variable for Snap to calculate the difference between the time when the respondent left home and their arrival time.<\/p>\n<ol>\n<li>Click <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22698\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/07\/VariablesButton.png\" alt=\"VariablesButton\" width=\"24\" height=\"22\" \/>\u00a0to open the Variables window.<\/li>\n<li>Click <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17366\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/11\/add.png\" alt=\"add\" width=\"15\" height=\"16\" \/>\u00a0to create a new variable.<\/li>\n<li>Set the Name to <strong>timedelay, <\/strong>the Type to <strong>Derived<\/strong> and the response to <strong>Quantity<\/strong>.<\/li>\n<li>Set a sensible Label (e.g, &#8220;Difference between leaving and arrival time in hours&#8221;)<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23813\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/deriv_time_days.png\" alt=\"Showing a variable formula for calculating hours\" width=\"572\" height=\"405\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/deriv_time_days.png 572w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/deriv_time_days-150x106.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/deriv_time_days-500x354.png 500w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/li>\n<li>Set up the formula in the <strong>Valid <\/strong>field.<\/li>\n<li>The first part of the formula is working out the days spent on the journey and converting it to hours by multiplying it by 24.<br \/>\n<code>(DateB-DateA)*24<\/code><\/li>\n<li>The second part of the formula is the difference between the two times. If you subtract one time from another in Snap, Snap always give you a positive value. If the second time is before the first, Snap assumes that one must be before midnight and one must be after midnight, and works out a time across midnight. This means that 10am &#8211; 9pm gives 13 hours rather than -11 hours. Snap works out time differences in seconds. To convert the time difference to hours, you must divide it by 3600<br \/>\n<code>(TimeB-TimeA)\/3600<\/code><code><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23819\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/time_calc_form.png\" alt=\"Time formula showing second conversion\" width=\"549\" height=\"135\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/time_calc_form.png 549w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/time_calc_form-150x37.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/time_calc_form-500x123.png 500w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><br \/>\n<\/code><\/li>\n<li>The last part of the formula is to sort out what happens if the second time was before the first. The diagram below shows a journey starting at 9pm on Monday 1st and ending at 10am on Thursday 4th.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23810\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/calendar_arr.png\" alt=\"CD: calendar showing arrow across several days\" width=\"583\" height=\"76\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/calendar_arr.png 583w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/calendar_arr-150x20.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/calendar_arr-500x65.png 500w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/>The first part of the formula gives the days. (4 &#8211; 1) gives three whole days. The second part of the formula gives the time. 10am &#8211; 9pm gives 13 hours. But that gives three days and thirteen hours, whereas it is really two whole days and thirteen hours. The formula therefore needs to subtract twenty-four hours from the total if the second time is before the first. To do this, you test to see if the second time is before the first using the logical expression <code>(TimeB&lt;TimeA)<\/code>. By using the <strong>num <\/strong>keyword, you can turn the result of the test into a numeric value, so it will be 1 for true and 0 for false. If you multiply this result by 24, you get the right number of hours to take away, 0 if TimeB isn&#8217;t smaller than TimeA, and 24 if it is.<code>(24 *num(TimeB&lt;TimeA))<\/code>So the whole formula reads:<code>(DateB-DateA)*24 + (TimeB-TimeA)\/3600 - 24*num(TimeB&lt;TimeA)<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23815\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/long_formula.png\" alt=\"Variable details howing full time formula\" width=\"560\" height=\"158\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/long_formula.png 560w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/long_formula-150x42.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/long_formula-500x141.png 500w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/code><\/li>\n<li>Press <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22703\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/07\/Save.png\" alt=\"Save\" width=\"24\" height=\"22\" \/>\u00a0or click \u00a0<strong>[Enter]<\/strong> to save your new variable.<\/li>\n<\/ol>\n<\/div>\n<div>\n<h3><a name=\"o22595\"><\/a>Step 4: Splitting up the data into bands for analysis<\/h3>\n<ol>\n<li>Click <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17366\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/11\/add.png\" alt=\"add\" width=\"15\" height=\"16\" \/>\u00a0to create a new variable to show the length of the journey.<\/li>\n<li>Set the Name to<strong> tripType<\/strong>, the Type to <strong>Derived<\/strong>, and the Response to <strong>Single<\/strong>. Add a label describing the variable function<\/li>\n<li>In the first Label field type <strong>Quick trip<\/strong>, and for its value type <strong>timedelay&lt;=2<\/strong>. All cases where the time taken is left than or equal to two hours will be stored as quick trips.<\/li>\n<li>In the second Label field type <strong>Medium trip<\/strong> and type <strong>timedelay &lt;=6 <\/strong>as the value. All cases where the time taken is 2 to 6 hours will be stored here.<\/li>\n<li>In the third Label field type <strong>Long trip<\/strong> and type <strong>timedelay &gt;6 <\/strong>as its values. All cases where the time taken is greater than six hours are stored as <strong>Long trips<\/strong>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23812\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/der_band_var.png\" alt=\"Variable showing banded trip type response\" width=\"572\" height=\"405\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/der_band_var.png 572w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/der_band_var-150x106.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/der_band_var-500x354.png 500w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/li>\n<\/ol>\n<p>You can now perform analyses using either the <strong>tripType <\/strong>or the <strong>timedelay <\/strong>variable. For example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23822\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/2d_trip_chart.gif\" alt=\"2D chart of trip length\" width=\"407\" height=\"397\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23818\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/stats_tab_prev.png\" alt=\"Preview of a simple stats table of timedelay\" width=\"217\" height=\"434\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/stats_tab_prev.png 217w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/stats_tab_prev-150x300.png 150w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/p>\n<\/div>\n<div>\n<h3><a name=\"o22620\"><\/a>Changing the variable names back to question numbers<\/h3>\n<p>When you changed the variable names to <strong>DateA<\/strong> and <strong>DateB<\/strong> et cetera, it will have confused the question numbering in your survey. You can change them back to <strong>Q1.a,<\/strong> <strong>Q2.a<\/strong> et cetera, and the variable names will automatically be changed in the formula for<strong> timedelay<\/strong>.<\/p>\n<p>Alternatively, you can hide the question numbers by selecting the questions, the choosing <strong>Show <\/strong>in the toolbar topics, <strong>Name <\/strong>in the dropdown list, and clearing the <strong>Show <\/strong>box.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23814\" src=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/hide_quest_num.png\" alt=\"Selected queestions with Show Name cleared\" width=\"680\" height=\"249\" srcset=\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/hide_quest_num.png 680w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/hide_quest_num-150x55.png 150w, https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2016\/11\/hide_quest_num-500x183.png 500w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/p>\n<\/div>\n<p>If there is a topic you would like a worksheet on, email to <a title=\"\" href=\"mailto:snapideas@snapsurveys.com\" target=\"_self\">snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p><a class=\"ninja_pages_read_more\"  href=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"parent":43,"menu_order":129,"comment_status":"open","ping_status":"closed","template":"page-templates\/child-page.php","meta":{"_acf_changed":false,"footnotes":""},"class_list":{"0":"post-5458","1":"page","2":"type-page","3":"status-publish","5":"search_category-support-hub"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculating the difference between times on different dates - Snap Surveys<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculating the difference between times on different dates - Snap Surveys\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/\" \/>\n<meta property=\"og:site_name\" content=\"Snap Surveys\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SnapSurveys\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-04T13:45:03+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@snapsurveys\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/\",\"name\":\"Calculating the difference between times on different dates - Snap Surveys\",\"isPartOf\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\"},\"datePublished\":\"2012-10-23T17:10:16+00:00\",\"dateModified\":\"2018-10-04T13:45:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Worksheets\",\"item\":\"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calculating the difference between times on different dates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.snapsurveys.com\/support-snap11\/#website\",\"url\":\"https:\/\/www.snapsurveys.com\/support-snap11\/\",\"name\":\"Snap Surveys\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculating the difference between times on different dates - Snap Surveys","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Calculating the difference between times on different dates - Snap Surveys","og_url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/","og_site_name":"Snap Surveys","article_publisher":"https:\/\/www.facebook.com\/SnapSurveys","article_modified_time":"2018-10-04T13:45:03+00:00","twitter_card":"summary_large_image","twitter_site":"@snapsurveys","twitter_misc":{"Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/","url":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/","name":"Calculating the difference between times on different dates - Snap Surveys","isPartOf":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website"},"datePublished":"2012-10-23T17:10:16+00:00","dateModified":"2018-10-04T13:45:03+00:00","breadcrumb":{"@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/calculating-difference-times-dates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.snapsurveys.com\/support-snap11\/"},{"@type":"ListItem","position":2,"name":"Worksheets","item":"https:\/\/www.snapsurveys.com\/support-snap11\/worksheets\/"},{"@type":"ListItem","position":3,"name":"Calculating the difference between times on different dates"}]},{"@type":"WebSite","@id":"https:\/\/www.snapsurveys.com\/support-snap11\/#website","url":"https:\/\/www.snapsurveys.com\/support-snap11\/","name":"Snap Surveys","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.snapsurveys.com\/support-snap11\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/5458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/comments?post=5458"}],"version-history":[{"count":10,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/5458\/revisions"}],"predecessor-version":[{"id":24983,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/5458\/revisions\/24983"}],"up":[{"embeddable":true,"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/www.snapsurveys.com\/support-snap11\/wp-json\/wp\/v2\/media?parent=5458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}