{"id":6124,"date":"2021-11-18T07:01:35","date_gmt":"2021-11-18T07:01:35","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=6124"},"modified":"2021-11-18T07:04:49","modified_gmt":"2021-11-18T07:04:49","slug":"subtracting-time-with-the-24-hr-clock-excel","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/subtracting-time-with-the-24-hr-clockexcel\/16031.html","title":{"rendered":"Subtracting Time With The 24 Hr Clock\/Excel"},"content":{"rendered":"<p>I am subtracting times in excel which works fine for (1:25AM &#8211; 3:00AM=-2:05) But once i get to (12:15AM &#8211; 11:50PM) I am coming into problems. This should be :25 but it&#8217;s showing me 23:35. Any ideas? I am using just the basic A1-B1.<\/p>\n<p>I am using a simple spread sheet representing:<br \/>\nA1=Scheduled Departure Time (3:15AM)<br \/>\nB1=Actual Departure Times (1:22AM)<br \/>\nB1-A1= -1:53<br \/>\nIf A1 is 12:15AM<br \/>\nB1 is 11:50PM<br \/>\nC1 ends up 23:35 not 0:25 that it should be.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":6},"question-category":[53],"question_tags":[],"class_list":["post-6124","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/6124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=6124"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=6124"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=6124"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=6124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}