Question: how to calculate a negative time in excel?
Answer: #1 click File tab, and select Options from the menu list. ...  #2 click Advanced from the left pane, and check Use 1904 data system under When calculating this workbook section. ...  #3 the negative time will be shown normally. Note: you should know that the returned result is actually a text value, not a numeric value.