The difference between two dates

**hesham63** · 07-29-2011, 03:39 PM

hi
I want to calculate the time between

**daddylonglegs** · 07-29-2011, 03:41 PM

For a difference between two dates you can just subtract the smaller date from the larger, e.g.

=B2-A2

**hesham63** · 07-29-2011, 03:50 PM

I'm sorry there is an error

**hesham63** · 07-29-2011, 03:53 PM

I'm sorry there is an error

I want to calculate the time between
start tim 11:00 PM
end time 3:00 AM

**ChemistB** · 07-29-2011, 04:03 PM

One way
=IF(A1>B1, 1-A1+B1,B1-A1)
Format cell as custom h:mm
Does that work for you?

**hesham63** · 07-29-2011, 04:15 PM

Thank you ........

Re: The difference between two dates