Date help

[mahitham]

Hi,

Can any one please help me on below requirement.

I have a field called Add Date in Time stamp format. From this Add Date field please help me to derive a Due Date field by adding 15 working Minutes.

Due Date= Add Date+15 Working Minutes.

A “working minute” is defined as any minute that falls between the hours of 09:00 and 17:30 on any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year. If either of the relevant date values falls outside of the “working minutes” definition  the value shall be amended for the purposes of this calculation to 09:00 on the next working day.

[Channa]

can you add data in xls 

[mahitham]

Hi @Channa 

Thanks for your reply.

Please find the below attached qvd with data.

I have added the working days definition also in the main thread. Please help me on this.

Thanks in advance.

[Channa]

try

=date(Date( DateTime,'DD/MM/YYYY HH:mm:ss')+MakeTime(00,15,00),'DD/MM/YYYY HH:mm:ss')

[mahitham]

Hi @Channa 

Thanks for your help.

But is this MakeTime() will consider only working minutes  from 09:00 and 17:30 in working days. Please confirm.

Due Date= Add Date+15 Working Minutes.

A “working minute” is defined as any minute that falls between the hours of 09:00 and 17:30 on any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year. If either of the relevant date values falls outside of the “working minutes” definition  the value shall be amended for the purposes of this calculation to 09:00 on the next working day. 

[Channa]

it just add 15 minits to your Adddate

17:00:18 it will make 17:15:18

[mahitham]

ok but I am looking for this

A “working minute” is defined as any minute that falls between the hours of 09:00 and 17:30 on any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year. If either of the relevant date values falls outside of the “working minutes” definition  the value shall be amended for the purposes of this calculation to 09:00 on the next working day.