As the title implies, I suck at math and trying to figure out what equation I need to make this work.
The best example of what I’m attempting to do is an employee “clock in/clock out” flow where the user taps “clock in” and it plugs the current date/time into an associated collection. Then, tapping “clock out” plugs that current date/time into a different field within the same associated collection.
I need to generate a result that tells me how many hours were worked between clock in and clock out. I’ve managed to generate some data but it’s terribly wrong, that is, for simplicity sake, I put clock in on todays date at 1AM and clock out on todays date at 5AM, and the hours worked result was 0.3256554 (yeah, not even close).
Any ideas?