| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exact differnce between 2 dates & time, networkday give round off
I want to find out the fraction differnce between two time points. e.g work
starts on 4th july 2008 13:11:45 and ends at 17th july 2008 18:23:23. Now I want to find exact working time spent on the activity. so it should not include holidays. I know networkdays give the answer but it gives answerin whole no. or round off value I want the answer in exact fractions. Pls guide me if anyone able to calculate so. I mean answer should come time 13.23 days. etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
exact differnce between 2 dates & time, networkday give round off
You got some pretty good answers yesterday. What was unsatisfactory about
those answers? We don't want to re-invent your wheel. -- Gary Brown "panks" wrote: I want to find out the fraction differnce between two time points. e.g work starts on 4th july 2008 13:11:45 and ends at 17th july 2008 18:23:23. Now I want to find exact working time spent on the activity. so it should not include holidays. I know networkdays give the answer but it gives answerin whole no. or round off value I want the answer in exact fractions. Pls guide me if anyone able to calculate so. I mean answer should come time 13.23 days. etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exact differnce between 2 dates & time networkdays give round off | Excel Worksheet Functions | |||
| How do I find the exact years and days between 2 dates? | Excel Discussion (Misc queries) | |||
| 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 | |||
Hybrid Mode
