If E22 contains both the date and time 8/16/2006 7:30 PM, and E23 contain
8/17/2006 5:30 AM, then all you need is this formula
=E23-E22

The formula you are using is for timesheets that allows for data to be
entered as time only (without the date). It multiplies by 24 to get a
decimal answer (10.25 instead of 10:15).

"Dtown Dawg" wrote:

I've serched and found some answers, but I'm just not sure If I doning
correctly.

I'm trying to have the .xls calculate the amount of time the user was
connected.

I currently have the following:
D22 D23
16-Aug-06 7:30:00 PM (This is when the User Connected)
17-Aug-06 5:30:00 AM (This is when the user Disconnected)

My current formula is:
=(E23-E22+(E23<E22))*24 Which gives me 240:00:00

But I want to see that that user was connected for 10:00:00

What am I doing wrong?