PDA

View Full Version : calculate time difference between cells



austenr
11-14-2017, 01:05 PM
How would you extract the time from a cell formatted as 01/01/2017 01:00 PM and get the difference from another cell with the same format without splitting the cells out into two columns?

Kenneth Hobs
11-14-2017, 03:08 PM
If they are date/time numbers, then =A1-B1. If more than 24 hours, convert the day difference to hours. e.g. =(A1-B1)*(24) or, do the A1-B1 but set the Number Format to [hh].

Paul_Hossler
11-14-2017, 03:17 PM
Not exactly sure I understand, but I think it's just a matter of subtracting and formatting


20960