Forum Discussion

NeilKloster's avatar
NeilKloster
Brass Contributor
Dec 28, 2022

calculate total hours between date/time (excluding weekends)

Hello,    I know that this is pretty easy for this group, but it's escaping me at the moment.  I want to calculate the hours between two fields, but I just want a simple number of hours.  No concat...
  • mtarler's avatar
    mtarler
    Dec 29, 2022

    NeilKloster  So there are 2 things happening here:

    a) any of the lines with start and end being the same day are 0 because you missed the last line of the equation

    b) the numbers look weird because you didn't format them to show [h]:mm

    If you want purely hours (i.e. [h]:mm of 1:30 would be 1.5) then just add 24* at the beginning (or *24 at the end) of the equation.

    see attached.

Resources