Subtracting time in Excel
in Software ·
There’s a whole lot of info here:
http://www.cpearson.com/excel/datearith.htm
But honestly, what you're actually looking for is this:
=IF(A1>B1;A1+1-B1;B1-A1)
In this scenario, think of A1 as your 10:00 PM and B1 as 6:00 AM.
http://www.cpearson.com/excel/datearith.htm
But honestly, what you're actually looking for is this:
=IF(A1>B1;A1+1-B1;B1-A1)
In this scenario, think of A1 as your 10:00 PM and B1 as 6:00 AM.