Home Forums Article Discussions Article Discussions by Author Discuss content posted by Megan Beebe Get Business Time RE: Get Business Time

  • April 28, 2009 at 11:51 am

    #985351

    Hi Megan,

    I just came across your work while browsing the site. Got curious and checked it randomly. Could you please explain the below results it is giving. How may working hours per day are you assuming and what is working schecdule (Start and End timings of work each working day)

    select [dbo].[fn_GetBusinessTimeElapsed] ('2009-04-24 07:18', '2009-04-28 20:18', 'HOURS')

    21

    select [dbo].[fn_GetBusinessTimeElapsed] ('2009-04-23 07:18', '2009-04-28 20:18', 'HOURS')

    29

    Sincerely,

    Maz

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]