{"version":"1.0","provider_name":"GLOBIS Unlimited","provider_url":"https:\/\/globisunlimited.com\/jp","author_name":"GLOBIS Unlimited","author_url":"https:\/\/globisunlimited.com\/jp","title":"Excel Functions &amp; Formulas: Date &amp; Time - GLOBIS Unlimited","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"8aNDnhZfij\"><a href=\"https:\/\/globisunlimited.com\/jp\/course\/excel-functions-formulas-date-time\/\">Excel Functions &amp; Formulas: Date &amp; Time<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/globisunlimited.com\/jp\/course\/excel-functions-formulas-date-time\/embed\/#?secret=8aNDnhZfij\" width=\"600\" height=\"338\" title=\"&#8220;Excel Functions &amp; Formulas: Date &amp; Time&#8221; &#8212; GLOBIS Unlimited\" data-secret=\"8aNDnhZfij\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/globisunlimited.com\/wp-includes\/js\/wp-embed.min.js\n<\/script>","thumbnail_url":"https:\/\/globisunlimited.com\/wp-content\/uploads\/2022\/12\/Globis.jpg","thumbnail_width":1910,"thumbnail_height":1000,"description":"When entering date and time in Excel, it is important that Excel recognizes our input appropriately and lets us subtract or add time to it. Understanding how values of a date and time are stored in different formatting options is therefore essential. This course covers how to: \u2022\u00a0Enter date and time in Excel and perform calculations with it, \u2022\u00a0Use the TODAY and NOW functions to return the current date and time, \u2022\u00a0Change the date and time formatting, \u2022 And, use the EOMONTH function to find the last day of a given month. Join us, and see how you can display date and time in Excel according to your needs."}