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
Actually disregard that last message. Its working now. Thanks a lot!
------------------------------
Wallace Yeboah
------------------------------
------------------------------
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
------------------------------
------------------------------
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
------------------------------
