Converting time

T

tibbsu2

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.
 
T

Toppers

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

A1=Start time
B1=Finish time
 
B

Bernard Liengme

It would have helped to see your formula
Assume:
A1 has start time
B1 has end time (and this could be the next day)
Use =(B1-A1)+(B1<A1)

The last term adds 1 day (i.e. 24 hours) if the second time is next day
Format the cell with hh:mm
best wishes
 
Top