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
------------------------------ - Actually disregard that last message. Its working now. Thanks a lot!
------------------------------
Wallace Yeboah
------------------------------- Wallace Yeboah, how did you get it to work? I am getting an error message on the last line that says "expecting text but found time of day"
------------------------------
Courtneah Thomas
------------------------------- 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
------------------------------
