{"id":1709,"date":"2023-11-10T09:45:03","date_gmt":"2023-11-10T09:45:03","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/"},"modified":"2023-12-10T06:22:18","modified_gmt":"2023-12-10T06:22:18","slug":"secondi-a-ore-minuti","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/","title":{"rendered":"Come convertire i secondi in ore e minuti?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-3955457138\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Per convertire i secondi in ore o minuti in Excel, devi dividere il valore dei secondi che hai per il numero totale di secondi che hai in un singolo giorno. Successivamente, \u00e8 necessario modificare il formato in ore e minuti. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80514\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"convertire i secondi in ore e minuti\" width=\"583\" height=\"268\"><\/figure><\/div><p> In questo tutorial imparerai come scrivere e comprendere queste formule in dettaglio. Per tuo riferimento, nell&#8217;esempio seguente hai 10000 secondi nella cella A1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-secondes-comme-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"secondo come valori\" width=\"433\" height=\"194\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Convertire i secondi in ore (hh:mm:ss)<\/h2><p> Ecco i passaggi per scrivere questa formula:<\/p><ol><li> Innanzitutto, in una cella, inserisci la formula per dividere i secondi per 86400 (il numero totale di secondi in un giorno). <br><img loading=\"lazy\" decoding=\"async\" title=\"3-divide-i-secondi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-diviser-les-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"divide-the-seconds\" width=\"515\" height=\"262\"><\/li><li> Successivamente, apri <a href=\"https:\/\/exceladvisor.org\/it\/opzioni-di-cella-in-formato-aperto\/\">Opzioni formato (Ctrl+1)<\/a> . <br><img loading=\"lazy\" decoding=\"async\" title=\"Formato aperto a 4 celle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-au-format-ouvert.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-format-cells\" width=\"513\" height=\"358\"><\/li><li> Ora, nell&#8217;elenco delle categorie, fai clic su &#8220;Personalizzato&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-seleziona-categoria-personalizzata\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionnez-la-categorie-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-custom-category\" width=\"596\" height=\"323\"><\/li><li> Quindi, nella barra di immissione del testo, inserisci [hh]:mm o [hh]:mm:ss. <br><img loading=\"lazy\" decoding=\"async\" title=\"Valore personalizzato a 6 input\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-entrez-la-valeur-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-custom-value\" width=\"593\" height=\"290\"><\/li><li> Alla fine, fai clic su OK per applicare la formattazione.<\/li><\/ol><p> Quando si preme OK, viene visualizzato il numero totale di ore e minuti. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-nombre-total-dheures-et-de-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"numero totale di ore e minuti\" width=\"475\" height=\"238\"><\/figure><\/div><p class=\"grey-note\"> <strong>Invece di usare hh:mm:ss, qui usiamo [hh]:mm o [hh]:mm:ss.<\/strong><\/p><p class=\"grey-note\"> Perch\u00e9 quando usi hh:mm e hai secondi in pi\u00f9 rispetto al numero totale di secondi in un giorno, otterrai un risultato negativo.<\/p><p class=\"grey-note\"> Se hai 27 ore ti dir\u00e0 3 ore oltre le 24 ore giornaliere. Questo \u00e8 il motivo per cui dovresti usare [hh]:mm:ss e [hh]:mm.<\/p><h2 class=\"wp-block-heading\"> Converti i secondi in minuti<\/h2><p> Allo stesso modo, puoi convertire i secondi in minuti, devi seguire gli stessi passaggi, ma devi utilizzare un formato personalizzato diverso. Dopo aver inserito la formula nella cella, modifica il formato in [mm]:ss e fai clic su OK. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-convertir-des-secondes-en-minutes.png\" sizes=\"auto, \" srcset=\"\" alt=\"convertire secondi in minuti\" width=\"782\" height=\"338\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Utilizzo della funzione testo per convertire i secondi in ore e minuti<\/h2><p> S\u00ec, puoi utilizzare anche la funzione TESTO. Ci\u00f2 consente la conversione di secondi nel risultato desiderato senza modificare il formato della cella. Nella funzione TESTO, \u00e8 possibile specificare il formato all&#8217;interno della funzione. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-fonctions-de-texte-pour-convertir-les-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"funzione-testo-per-convertire-secondi\" width=\"606\" height=\"228\"><\/figure><\/div><p> Nel primo argomento di TESTO, devi inserire la stessa formula secondi\/secondi totali in un giorno. Successivamente, nel secondo argomento (text_format), inserisci il formato che vuoi dare.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TEXT(A1\/86400,\"[hh]:mm\") =TEXT(A1\/86400,\"[mm]:ss\")<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Ottieni il file Excel<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-les-secondes.xlsx\" rel=\"nofollow\">Scaricamento<\/a> <\/p><\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Pi\u00f9 formule<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/tempo-in-minuti-2\/\">Converti il valore temporale in minuti (formula Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/tempo-in-secondi-2\/\">Converti il valore temporale in secondi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/ora-corrente-2\/\">Ottieni l&#8217;ora corrente (formula Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/lora-del-pisolino-2\/\">Somma del tempo in Excel (formula di Excel)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/aggiungere-secondi-al-tempo\/\">Aggiungi secondi al tempo<\/a><\/li><\/ul><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1709","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Come convertire i secondi in ore e minuti in Excel<\/title>\n<meta name=\"description\" content=\"Questo tutorial ti insegner\u00e0 come scrivere una formula Excel per convertire i secondi in ore e minuti. Controlliamo questo...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come convertire i secondi in ore e minuti in Excel\" \/>\n<meta property=\"og:description\" content=\"Questo tutorial ti insegner\u00e0 come scrivere una formula Excel per convertire i secondi in ore e minuti. Controlliamo questo...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:22:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/\",\"name\":\"Come convertire i secondi in ore e minuti in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\",\"datePublished\":\"2023-11-10T09:45:03+00:00\",\"dateModified\":\"2023-12-10T06:22:18+00:00\",\"description\":\"Questo tutorial ti insegner\u00e0 come scrivere una formula Excel per convertire i secondi in ore e minuti. Controlliamo questo...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come convertire i secondi in ore e minuti?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come convertire i secondi in ore e minuti in Excel","description":"Questo tutorial ti insegner\u00e0 come scrivere una formula Excel per convertire i secondi in ore e minuti. Controlliamo questo...","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:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/","og_locale":"it_IT","og_type":"article","og_title":"Come convertire i secondi in ore e minuti in Excel","og_description":"Questo tutorial ti insegner\u00e0 come scrivere una formula Excel per convertire i secondi in ore e minuti. Controlliamo questo...","og_url":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:22:18+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/","url":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/","name":"Come convertire i secondi in ore e minuti in Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","datePublished":"2023-11-10T09:45:03+00:00","dateModified":"2023-12-10T06:22:18+00:00","description":"Questo tutorial ti insegner\u00e0 come scrivere una formula Excel per convertire i secondi in ore e minuti. Controlliamo questo...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-convertir-les-secondes-en-heures-et-minutes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/secondi-a-ore-minuti\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come convertire i secondi in ore e minuti?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1709"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1709\/revisions"}],"predecessor-version":[{"id":2412,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1709\/revisions\/2412"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}