| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help Calculate Time Between 2 different Dates
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel calculate time increments in a formula? | Excel Worksheet Functions | |||
| formula to calculate time difference crossing midnight | Excel Worksheet Functions | |||
| Importing dates and military time from Excel into word doc mail me | Excel Discussion (Misc queries) | |||
| calculate total service time in excel | Excel Discussion (Misc queries) | |||
| calculate elapsed time between dates and times | Excel Worksheet Functions | |||
Threaded Mode
