Prev: how do I strip spaces and replace with dashes
Next: Setting up an Email to automatically be sent based off a date
From: Alaska1 on 27 Apr 2010 18:07
I am using the DateDiff function in a report. I am using it based on 16
hours to caluclate process time of work. I need to include a 5 day work
week. if a worker gets something on Friday at 4:00pm and does not complete
until Monday morning. How do I calculate that time?
From: KenSheridan via AccessMonster.com on 27 Apr 2010 18:32
Try something like this:

DateDiff("h",IIf(WeekDay([DateTimeStart])=6, [DateTimeStart]+2,
[DateTimeStart]), [DateTimeEnd])

Ken Sheridan
Stafford, England

Alaska1 wrote:
>I am using the DateDiff function in a report. I am using it based on 16
>hours to caluclate process time of work. I need to include a 5 day work
>week. if a worker gets something on Friday at 4:00pm and does not complete
>until Monday morning. How do I calculate that time?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201004/1

From: KenSheridan via AccessMonster.com on 27 Apr 2010 18:44
PS: That assumes anything started on a Friday is not completed until Monday
of course. If a task could start and finish on the Friday try this:

DateDiff("h",IIf(WeekDay([DateTimeStart])=6,[DateTimeStart]+2, [DateTimeStart]
), IIf(WeekDay([DateTimeStart])=6 And WeekDay([DateTimeEnd])=6, [DateTimeEnd]
+2, [DateTimeEnd]))

Ken Sheridan
Stafford, England

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201004/1

From: ilan karaoğlu on 28 Apr 2010 06:44


"Alaska1" <Alaska1(a)discussions.microsoft.com>, iletide şunu yazdı
news:68406EF8-3EFF-4163-950D-27597D6A4F92(a)microsoft.com...
> I am using the DateDiff function in a report. I am using it based on 16
> hours to caluclate process time of work. I need to include a 5 day work
> week. if a worker gets something on Friday at 4:00pm and does not
> complete
> until Monday morning. How do I calculate that time?

From: Alaska1 on 28 Apr 2010 09:28
Thank you. I tried both formulas and used a start date of 4/23/2010 and end
date of 4/26/2010 which is a friday to a monday. It is calculating in the 8
hours for saturday and sunday.

"KenSheridan via AccessMonster.com" wrote:

> PS: That assumes anything started on a Friday is not completed until Monday
> of course. If a task could start and finish on the Friday try this:
>
> DateDiff("h",IIf(WeekDay([DateTimeStart])=6,[DateTimeStart]+2, [DateTimeStart]
> ), IIf(WeekDay([DateTimeStart])=6 And WeekDay([DateTimeEnd])=6, [DateTimeEnd]
> +2, [DateTimeEnd]))
>
> Ken Sheridan
> Stafford, England
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/201004/1
>
> .
>
 |  Next  |  Last
Pages: 1 2 3 4 5
Prev: how do I strip spaces and replace with dashes
Next: Setting up an Email to automatically be sent based off a date