Date and Time Difference
Posted: Wed Nov 15, 2006 6:08 pm
How can I find the date and time difference between two days and the two days is calculated during office hours only??
For example :
Official timings are 9.00 am to 6.00 pm
1.only official time is taken into consideration.
2.saturdays and sundays are not considered.
Time IN : 16/11/06 4.00 pm (THURSDAY)
Time OUT : 17/11/06 2.05pm (FRIDAY)
so my answer should be 7 hours and 5 minutes.
Time IN : 17/11/06 3.00pm (FRIDAY)
Time OUT : 21/11/06 11.37pm (TUESDAY)
friday 3 hours
monday 9 hours
tuesday 2 hours 37 minutes
so totally diff is 14 hours and 37 minutes.
anyway i can archieve this ??
For example :
Official timings are 9.00 am to 6.00 pm
1.only official time is taken into consideration.
2.saturdays and sundays are not considered.
Time IN : 16/11/06 4.00 pm (THURSDAY)
Time OUT : 17/11/06 2.05pm (FRIDAY)
so my answer should be 7 hours and 5 minutes.
Time IN : 17/11/06 3.00pm (FRIDAY)
Time OUT : 21/11/06 11.37pm (TUESDAY)
friday 3 hours
monday 9 hours
tuesday 2 hours 37 minutes
so totally diff is 14 hours and 37 minutes.
anyway i can archieve this ??