ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding the difference between 2 times (https://www.excelbanter.com/excel-programming/393955-finding-difference-between-2-times.html)

erighter

Finding the difference between 2 times
 
I am trying to find the difference between 2 times to determine the amount of
time lost between 2 events.

A1: First event ends at 6:00 AM (time format)
A2: Second event begins at 10:00 AM (also time format)

I'd like to express the time lost between those two in hh:mm format.
(A2 - A1)*24 = 20:00 --- I'd expect 04:00 to show that there's 4 hrs
between.

When A1 = 4:30 AM and A2 = 9:30 AM, the calculation correctly shows 05:00
in time lost.

Where am I going wrong?


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com