I have a timecard app where users input their in and out times. Very simple. I have a date/time field where the data is being stored, but no date/time is being displayed. Any ideas? I tried removing the field and adding it again. Its definitely storing the data in my sheet…
At the bottom there is a math field that caclulates the number of hours worked. You can see that all these fields are filled out because it computes 7.9 hours worked.
Yes, I think that’s the problem. Notice how the column type is set as “None”?
Try changing that to date/time, and set the display as time only (or whatever is appropriate).
I suspect that will fix the problem.
You’re trying to show “time only” then use a date/time picker to “pick” that. What if you use a date & time display instead of time only? Does it solve the problem?
We only have date pickers, date time pickers, no time pickers, I believe.