{"id":19672,"date":"2020-06-08T00:08:08","date_gmt":"2020-06-08T07:08:08","guid":{"rendered":"https:\/\/edelalon.com\/blog\/?p=19672"},"modified":"2020-06-25T09:27:57","modified_gmt":"2020-06-25T16:27:57","slug":"convert-hhmmss-to-hours-minutes-seconds-in-excel","status":"publish","type":"post","link":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/","title":{"rendered":"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel"},"content":{"rendered":"

I was stuck trying to figure out some Excel formulas because my data set decided to capture how long something takes into the format hh:mm:ss. At the same time, Excel and many other programs view that format as time of day.<\/p>\n

This is for example, how long did it take you to build the fence? 10:05:30. As in 10 hours, 5 minutes, and 30 seconds. Excel will read this as 10:05AM and 30 seconds. Doing analysis on is strange because people really just want to know how long it took in terms of minutes or hours and adding times will not produce the results you would like. Adding time works but when you would like to add 15 minutes to hh:mm:ss it can get complicated.<\/p>\n

Here\u2019s the quick and dirty solution<\/h1>\n

In order to get from hh:mm:ss to a solid number you can use the following formulas:<\/p>\n

hh:mm:ss * 24 = TOTAL NUMBER OF HOURS (you might want decimal points)<\/p>\n

hh:mm:ss * 1440 = TOTAL NUMBER OF MINUTES (you might want decimal points)<\/p>\n

hh:mm:ss * 86400 = TOTAL NUMBER OF SECONDS<\/p>\n

To take out the individual hours, minutes, seconds<\/h1>\n

In Excel, if you just want the hours from hh:mm:ss, the formula is:<\/p>\n

=hour(cell where the data is located)<\/p>\n

In Excel, if you just want the minutes from hh:mm:ss the formula is:<\/p>\n

=minute(cell where the data is located)<\/p>\n

In Excel, if you just want the seconds from hh:mm:ss the formula is:<\/p>\n

=second(cell where the data is located)<\/p>\n

Here’s the long way to convert time<\/h1>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

I was stuck trying to figure out some Excel formulas because my data set decided to capture how long something takes into the format hh:mm:ss. At the same time, Excel and many other programs view that format as time of day. This is for example, how long did it take you to build the fence? […]<\/p>\n","protected":false},"author":1,"featured_media":19833,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":"","footnotes":""},"categories":[8],"tags":[109,111],"class_list":["post-19672","post","type-post","status-publish","format-standard","has-post-thumbnail","category-tools","tag-excel","tag-formulas"],"yoast_head":"\nConvert hh:mm:ss to Hours, Minutes, Seconds in Excel • Edel Alon<\/title>\n<meta name=\"description\" content=\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel • Edel Alon\" \/>\n<meta property=\"og:description\" content=\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Edel Alon\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-08T07:08:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-25T16:27:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/excel_time_to_number-696x436-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"696\" \/>\n\t<meta property=\"og:image:height\" content=\"436\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Edel Alon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Edel Alon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/\"},\"author\":{\"name\":\"Edel Alon\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"headline\":\"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel\",\"datePublished\":\"2020-06-08T07:08:08+00:00\",\"dateModified\":\"2020-06-25T16:27:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/\"},\"wordCount\":271,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"image\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/excel_time_to_number-696x436-1.jpg\",\"keywords\":[\"excel\",\"formulas\"],\"articleSection\":[\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/\",\"name\":\"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel • Edel Alon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/excel_time_to_number-696x436-1.jpg\",\"datePublished\":\"2020-06-08T07:08:08+00:00\",\"dateModified\":\"2020-06-25T16:27:57+00:00\",\"description\":\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/excel_time_to_number-696x436-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/excel_time_to_number-696x436-1.jpg\",\"width\":696,\"height\":436},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/convert-hhmmss-to-hours-minutes-seconds-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/\",\"name\":\"Edel Alon\",\"description\":\"Projects, Tools, Craft, Food, Music, and Other Stuff\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\",\"name\":\"Edel Alon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"contentUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"width\":136,\"height\":80,\"caption\":\"Edel Alon\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\"},\"description\":\"Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.\",\"sameAs\":[\"https:\\\/\\\/edelalon.com\"],\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/author\\\/edelalon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel • Edel Alon","description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","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:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel • Edel Alon","og_description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","og_url":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/","og_site_name":"Edel Alon","article_published_time":"2020-06-08T07:08:08+00:00","article_modified_time":"2020-06-25T16:27:57+00:00","og_image":[{"width":696,"height":436,"url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/excel_time_to_number-696x436-1.jpg","type":"image\/jpeg"}],"author":"Edel Alon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Edel Alon","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/"},"author":{"name":"Edel Alon","@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"headline":"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel","datePublished":"2020-06-08T07:08:08+00:00","dateModified":"2020-06-25T16:27:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/"},"wordCount":271,"commentCount":0,"publisher":{"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"image":{"@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/excel_time_to_number-696x436-1.jpg","keywords":["excel","formulas"],"articleSection":["Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/","url":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/","name":"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel • Edel Alon","isPartOf":{"@id":"https:\/\/www.edelalon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/excel_time_to_number-696x436-1.jpg","datePublished":"2020-06-08T07:08:08+00:00","dateModified":"2020-06-25T16:27:57+00:00","description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","breadcrumb":{"@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#primaryimage","url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/excel_time_to_number-696x436-1.jpg","contentUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/excel_time_to_number-696x436-1.jpg","width":696,"height":436},{"@type":"BreadcrumbList","@id":"https:\/\/www.edelalon.com\/blog\/convert-hhmmss-to-hours-minutes-seconds-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.edelalon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Convert hh:mm:ss to Hours, Minutes, Seconds in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.edelalon.com\/blog\/#website","url":"https:\/\/www.edelalon.com\/blog\/","name":"Edel Alon","description":"Projects, Tools, Craft, Food, Music, and Other Stuff","publisher":{"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.edelalon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42","name":"Edel Alon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","contentUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","width":136,"height":80,"caption":"Edel Alon"},"logo":{"@id":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png"},"description":"Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.","sameAs":["https:\/\/edelalon.com"],"url":"https:\/\/www.edelalon.com\/blog\/author\/edelalon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts\/19672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/comments?post=19672"}],"version-history":[{"count":0,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts\/19672\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/media\/19833"}],"wp:attachment":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/media?parent=19672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/categories?post=19672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/tags?post=19672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}