Rounding Time to nearest quarter

Question

&nbsp;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") + $RoundedClockInI keep&nbsp;receiving this error "The operator "-"&nbsp;can't be applied on types date/time, timeofday.Any help would be greatly appreciated&nbsp;------------------------------Wallace Yeboah------------------------------

markshnier__you · Answer

try thisvar datetime MidnightOfClockInDay = ToTimestamp(ToDate([Clock In Date Time]), ToTimeOfDay("12:00 am"));var duration RoundedDuratonfromMidnight = Round([Clock In Date Time] - $MidnightOfClockInDay, Minutes(15));ToTimeOfDay("12:00 am") + $RoundedDuratonfromMidnight------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

wallaceyeboah · Answer

Thanks for the response Mark! I'm still getting this error for the last line of code:"Expecting duration but found timeofday"------------------------------Wallace Yeboah------------------------------

wallaceyeboah · Answer

Actually disregard that last message. Its working now. Thanks a lot!------------------------------Wallace Yeboah------------------------------

courtneahthomas · Answer

Wallace Yeboah,&nbsp; how did you get it to work?&nbsp; I am getting an error message on the last line that says "expecting text but found time of day"------------------------------Courtneah Thomas------------------------------

kevinhaigler · Answer

Hi Courtneah,the ToTimeOfDay function will convert the return to a time of day data type, if your formula is expecting text, then your field type is formula-text. You can either update this to Date/Time, or use one of the other conversion functions (ToText). Though I'm not sure what kind of display you'll get converting this to text.I'd recommend changing your field type to Date/Time or Duration depending on your use case.------------------------------Kevin Haigler------------------------------

Forum Discussion

Rounding Time to nearest quarter

Related Content

Rich Text Button with rounded edge

Clock in/out round to the nearest quarter hour

I need my duration field to round to the nearest quarter hour.

Philly Qrew Round 2!!

Jinja2 Expressions for date quarter