Rounding down hour/minutes

[#1]

Hello,

I have captured the time intervals between to date/time fields.  An example of my result is:  52:15:00.  This represents 52 hour and 15 min between the two dates.  I would like to round down to 52.  I don't need the minutes and seconds.

Thanks

[#2]

Try following :

time(round( time#([Time],'hh.mm.ss'),maketime(0,30))) as RoundedTime

[#3 · Accepted solution]

I was able to accomplish it by doing this

num(Left(TimeField, Len(TimeField)-6))