{"id":1409,"date":"2018-07-04T14:46:39","date_gmt":"2018-07-04T14:46:39","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1409"},"modified":"2023-11-03T14:30:48","modified_gmt":"2023-11-03T14:30:48","slug":"timevalue","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/","title":{"rendered":"TIMEVALUE function"},"content":{"rendered":"\n<p>Excel TIMEVALUE Function is a built-in function that allows you to convert a time string into a decimal number, making it easier to work with time values in your spreadsheets.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>TIMEVALUE(time_text)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>time_text<\/strong><\/td><td>The time text you want to convert into a decimal time value.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>You can use the TIMEVALUE function to convert a time string into a decimal number. Here&#8217;s how you can do it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TIMEVALUE(\"10:30 AM\")<\/code><\/pre>\n\n\n\n<p>This formula will return 0.4375, which represents 10 hours and 30 minutes in decimal form.<\/p>\n\n\n\n<p>You can also use this function to convert time values in cells. For example, if cell A1 contains the text &#8220;2:45 PM,&#8221; you can use the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TIMEVALUE(A1)<\/code><\/pre>\n\n\n\n<p>This formula will return 0.614583333, which represents 2 hours and 45 minutes in decimal form.<\/p>\n\n\n\n<p>It&#8217;s important to note that the TIMEVALUE function assumes the time text is in a valid time format. If the text is not a recognized time, you&#8217;ll get an error.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Examples<\/h2>\n\n\n\n<p>Here are some examples of how to use the TIMEVALUE function:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TIMEVALUE(\"8:15 AM\")<\/code><\/pre>\n\n\n\n<p>This formula returns 0.34375, representing 8 hours and 15 minutes.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TIMEVALUE(\"3:30 PM\")<\/code><\/pre>\n\n\n\n<p>This formula returns 0.645833333, representing 3 hours and 30 minutes.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TIMEVALUE(\"12:00 AM\")<\/code><\/pre>\n\n\n\n<p>This formula returns 0, as it represents midnight (0 hours and 0 minutes).<\/p>\n\n\n\n<p>These examples demonstrate how you can use the TIMEVALUE function to convert time text into decimal time values, making it easier to perform calculations and work with time in your Excel spreadsheets.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel TIMEVALUE Function is a built-in function that allows you to convert a time string into a decimal number, making it easier to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>TIMEVALUE function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TIMEVALUE function\" \/>\n<meta property=\"og:description\" content=\"Excel TIMEVALUE Function is a built-in function that allows you to convert a time string into a decimal number, making it easier to...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T14:46:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T14:30:48+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"TIMEVALUE function\",\"datePublished\":\"2018-07-04T14:46:39+00:00\",\"dateModified\":\"2023-11-03T14:30:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\"},\"wordCount\":226,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\",\"name\":\"TIMEVALUE function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T14:46:39+00:00\",\"dateModified\":\"2023-11-03T14:30:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/timevalue\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TIMEVALUE function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TIMEVALUE function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/","og_locale":"en_US","og_type":"article","og_title":"TIMEVALUE function","og_description":"Excel TIMEVALUE Function is a built-in function that allows you to convert a time string into a decimal number, making it easier to...","og_url":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/","article_published_time":"2018-07-04T14:46:39+00:00","article_modified_time":"2023-11-03T14:30:48+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"TIMEVALUE function","datePublished":"2018-07-04T14:46:39+00:00","dateModified":"2023-11-03T14:30:48+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/"},"wordCount":226,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/","url":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/","name":"TIMEVALUE function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T14:46:39+00:00","dateModified":"2023-11-03T14:30:48+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/timevalue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/timevalue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"TIMEVALUE function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1409"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1409"}],"version-history":[{"count":2,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1409\/revisions"}],"predecessor-version":[{"id":16593,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1409\/revisions\/16593"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}