Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
TASK | Start -Time End-Time | ||
A | 8/31/2015 11:28:03 AM 8/31/2015 11:45:03 AM | ||
B | 8/28/2015 18:45:08 pM 9/2/2015 17:28:03 PM (29 and 30-sat sunday) | ||
C | 8/14/2015 09:10:07 pM 8/20/2015 13:28:03 PM (15 and 16-sat sunday and 17th -holiday) |
office time between 9AM to 6PM
I want to findout the actual time taken by TASK A ,TASK B, TASK C
interval(Endtime-StartTime,'hh:mm:ss')
Hi Sumar,
As Sasi Suggested Use Networkdays as mentioned below..
=networkdays(start_time,end_time)*9 (as the difference between 9AM to 6PM is 9 hours here).
HTH
Sreeni
networkdays (start:date, end_date {, holiday})
Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.
Examples:
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8
Hi,
Re: Calculate hours between two Date/Time strings
I have gone through this link. yes whatever presnt in this document will help me but i am not able to incorporate it.
Could you help me please.
I need time defferenc ebetween two days-
Please if possible need your help.
PLS help iu am not able to do it.
below is the definitiona and an example of network days - you should be able to replace the two differrent days in quotes with your field/variables for start time and end time
Definition:
networkdays
Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.
Examples
networkdays(‘2007-02-19’, ‘2007-03-01’) returns 9
networkdays(‘2006-12-18’, ‘2006-12-31’, ‘2006-12-25’, ‘2006-12-26’) returns 8
Hi Suman,
I've analyzed your problema, and I manage to get the time interval between the Request Date and the Resolved Date which I think it's want you are after. Open the qwv that I make and analyze the straight table that I created. If this is not your solution please tell me
Miguel
Hi,
Thanks for your help.
I have requested to consider -
1. Sat, sunday and holiday
2. We usually works 8 hours, so we have to condirer all thos information while any calculation.
Please need help.
Regards