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?
Printable View
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?
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].
Not exactly sure I understand, but I think it's just a matter of subtracting and formatting
Attachment 20960