exact differnce between 2 dates & time, networkday give round off

P

panks

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.
 
G

Gary Brown

You got some pretty good answers yesterday. What was unsatisfactory about
those answers?
We don't want to re-invent your wheel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exact differnce between 2 dates & time networkdays give round off 1
IF(M2="","",(NETWORKDAYS(F2,M2))+TIME(17,0,0)-F2+M2-TIME(8,0,0)) 7
How do I find elapsed time between 2 dates and times? 5
Generating business days in a calendar month, EXCLUDING holidays 1
How do I calculate exact difference between two dates in y,m,d. 3
Another Days, Hours, Minutes, Question 6
How to find the time elapsed between 2 events 1
Difference between 2 dates, incl weekends, with variable work days 4

Top