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:0...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
var 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thanks for the response Mark! I'm still getting this error for the last line of code:
"Expecting duration but found timeofday"
------------------------------
Wallace Yeboah
------------------------------
"Expecting duration but found timeofday"
------------------------------
Wallace Yeboah
------------------------------