I have below requirements which i want to find the differences in their time frame.
I do concatenation if Modified Time and Modified Date in to one Column Name (Modified Final)
Again I combine Create Date and Create Time in to column name (Create Final)
Recent Modified Time along with Modified Date.Modified Time Modified Date Create Date Create Time Final Result 1/1/2010 10:01 1/1/2010 9:30 1/1/2010 1/1/2010 10:01 2/2/2010 12:00 1/1/2010 10:00 2/2/10 12:00 2/1/2010 10:01 2/1/2010 10:00 2/1/2010 10:01
I want to calculate Difference between this
=(Modified Date & Modified Time- Creation Date and Creation Time) and Eliminate Weekends in this range fields.
Final Result Should be
= (Modified Date and Time (days calculate weekdays)- Creation Date and Time(Weekends))