Reply to thread

Message: <blockquote data-quote="saja" data-source="post: 29392924" data-attributes="member: 14999">=B2-A2Important: Before applying the formula, be sure to format the cells as time values. For instance, you can use the “h:mm AM/PM” time code or “h:mm:ss” time format. To do that:<ol> <li data-xf-list-type="ol">Select the cells you’ll be using, right-click on them and select Format Cells. Use the Ctrl + 1 shortcut to quickly launch the “Format Cells” dialog box.</li> <li data-xf-list-type="ol">Choose “Time” from the Category list and pick the time format you prefer.</li> <li data-xf-list-type="ol">Enter the times you want to compare (start time and end time) as shown in the example below.</li> <li data-xf-list-type="ol">In cell C2, type the formula “=B2-A2” (no quotes) and hit the Enter key on your keyboard to get the time difference between the two cells. The time difference will be displayed in hours and minutes. You can use the Custom option to customize the display of your time difference.</li> </ol>Let’s look at an example in Excel workbook: <img src="https://traqq.com/blog/wp-content/uploads/2023/04/How-to-calculate-time-difference-in-Excel.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />copied <a href="https://traqq.com/blog/how-to-calculate-time-difference-in-excel/" target="_blank">https://traqq.com/blog/how-to-calculate-time-difference-in-excel/</a></blockquote>

Top Bottom