| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exact differnce between 2 dates & time networkdays give round off
I would like to calculate differnce between two time instance without holidays.
so @ 4th july 2008 14:22:30 work started and it ended on 29th July 16:20:44 Then i want to calculate exact working time spent on the task. It should not include holidays. I know networkdays give the answer but it rounds off the result and I want exact differnce in fractions so that i can count upto exact seconds spent on process. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round, but give at least a value of 1 Q | Excel Worksheet Functions | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| NETWORKDAYS calc with 3 columns of dates | Excel Worksheet Functions | |||
| Calculating Dates Using Different Values for NETWORKDAYS | Excel Worksheet Functions | |||
Threaded Mode
