=MOD(B1-A1,1) will give difference in hours/minutes

A1=Start time
B1=Finish time

"tibbsu2" wrote:

I am going from before midnight to well after midnight and need to have excel
calculate this time. It is giving me a negative answer sometimes and other
times is gives me ######. I want to know if you can convert this so it just
calculates that time or will i need to figure that out with out excels help.
Its a lot of data so i prefer not to do this.