| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference between 2 time stamps
Hi All
I require a formula to compute the difference between 2 date stamps. Here is my requirement. We have time the issue is raised in K2 and target time to complete is in O2 for example K2 : 5/29/2009 4:15:21 PM O2: 6/1/2009 4:15:21 PM The difference between this 2 must be 8 hours as we work from Monday to friday timings 9.00 to 17.00 daily. Can anyone help me regarding this. Raj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup between two time stamps | Excel Worksheet Functions | |||
| Time Stamps??????????? | Excel Discussion (Misc queries) | |||
| I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps | Excel Discussion (Misc queries) | |||
| DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL | Excel Discussion (Misc queries) | |||
| Difference between two Excel Date/Time Stamps | Excel Worksheet Functions | |||
Threaded Mode
