Time difference

[Anonymous]

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

[gautik92]

interval(Endtime-StartTime,'hh:mm:ss')

[sasiparupudi1]

Use Networkdays..

may be check this thread

Re: Expression with Working Days and working Hours

hth

Sasi

[SreeniJD]

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

[avinashelite]

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 

[Anonymous]

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.

[Anonymous]

PLS help iu am not able to do it.

[#8]

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

[miguelbraga]

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

[Anonymous]

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