LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Find hours between two DateTimes

    Employee
    Posted 12-18-2014 20:04

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dglavastorm

    Hi Everyone - I need to determine the number of whole hours between 2 DateTimestamps . I've tried Datetimeadjust but can't get it to use 2 fields.

    CREATED DATE Closed Date
    2014-11-28 15:36:24 2014-11-29 13:27:24

    Thanks,

    Dave


  • 2.  RE: Find hours between two DateTimes

    Employee
    Posted 12-18-2014 20:10

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dglavastorm

    Never Mind - solved it :-) Subtract function gives milliseconds so just calculated from that.

    Filter formula if anyone else is trying to find this - Converts to hours, then rounds off from a double into an integer for rounded complete hours.

    HOURS = subtract('Closed Date','CREATED DATE')
    H1 = HOURS/1000
    H2 = H1/60
    H3 = H2/60
    H4 = H3.int()