Rounding up time

Ask for Help
1

I need to calculate the time difference between two dateTimeStamps in hours
Then I need to round up to the next hour. So if the duration between the times was 2 hours and 1 second, that is 3 hours.

I’m using Date Difference column that gives the answer in days. I then use maths column to multiply by 24 to give me hours.

What is the best/easiest way to now round up.

2

got it…

Maths trunc(jobDur * 24) + 1

where jobDur is a column calculated by Date Difference in hours

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.