If I don't multiply by 24 and only use (E23-E22) then the answer I get is:
################
So that didn't work.

"Pete_UK" wrote:

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?