Forum Discussion

Infonutt's avatar
Infonutt
Copper Contributor
Apr 04, 2018

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 post, so attached a pic, below

Formulas & Functions
Need Help
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 05, 2018
    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

Resources