Forum Discussion

WallaceYeboah's avatar
WallaceYeboah
Qrew Member
5 years ago

Rounding Time to nearest quarter

 I was wondering if there was a way to round the time in/out to the nearest quarter hour?

This is my current formula:

var duration RoundedClockIn = Round([Clock In Date Time] - ToTimeOfDay("12:00 am"), Minutes(15));

ToTimeOfDay("12:00 am") + $RoundedClockIn

I keep receiving this error "The operator "-" can't be applied on types date/time, timeofday.

Any help would be greatly appreciated 


------------------------------
Wallace Yeboah
------------------------------