| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference in date and time
Hope someone can help me with this.
I need to find the time difference between two dates excluding weekends. I have the dates formatted as "m/d/yyyy h:mm". The result has to be depicted in hours. If an order was placed at 4 PM on a Friday evening and delivery was at 11 AM Monday morning, what were the number of hours spent to service the request excluding the weekends (Saturday and Sunday) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Elapsed time: difference between 2 Date/Timestamp perio | Excel Worksheet Functions | |||
| Date and time difference | Excel Worksheet Functions | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| Difference between two Excel Date/Time Stamps | Excel Worksheet Functions | |||
| Difference of date & time in minutes | Excel Worksheet Functions | |||
Threaded Mode
