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.