Forum Discussion
Excel, subtracting time within the same hour
When I subtract time (G1-G2, H1-H2) within the same hour (7, 11 am) it comes back with the answer of 12 vs. 0. Works just fine if the hour is different.
--not sure how to place a pic in this ...
Change the number format of the cell with the formula to NOT use the AM/PM time format but use a format like hh:mm