You do not need to multiply by 24 in your formula.

Hope this helps.

Pete

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?