Forum Discussion

MelissaDoran's avatar
MelissaDoran
Qrew Cadet
8 years ago
You could have a field where the employee's entry is recorded, then you could have a second field that is rounded.
Maybe something like
Round(ToNumber(EmpTime),.25)
You'd have to turn it back into a time
Idk if you can round times w/o turning it to a number?

There's prob a cleaner solution but at least that's something.
And no i didn't test it, it's 1 AM and I need to go home.
Let me know how it goes though :)
  • JustinPauga's avatar
    JustinPauga
    Qrew Cadet
    8 years ago
    I've tried that but unfortunately the time in and out uses the Now() function which returns a date with the time so the ToNumber just gives me the number of the month. I appreciate the help though and it led me to some good resources for future formulas I will use but I still have the same issue regarding my timecard formula