HI!
I am writing a rather lengthy procedure that generates a time sheet report, calculating, Lunch, regular and overtime.
Here is a snipet
Lunch=DateDiff(Mi,Cast(StartLunch as DateTime),Cast(EndLunch as DateTime))
However I need to format this time so that it rounds up to the nearest 1/4 hour. If it returns 8:35AM it has to return 8:45AM if its 8:20AM it rounds to 8:30AM.
I just need an expression that will format the time field to round up to the nearest 1/4 hour.
I am writing a rather lengthy procedure that generates a time sheet report, calculating, Lunch, regular and overtime.
Here is a snipet
Lunch=DateDiff(Mi,Cast(StartLunch as DateTime),Cast(EndLunch as DateTime))
However I need to format this time so that it rounds up to the nearest 1/4 hour. If it returns 8:35AM it has to return 8:45AM if its 8:20AM it rounds to 8:30AM.
I just need an expression that will format the time field to round up to the nearest 1/4 hour.