Ya - we get the time sheets a day late, or significantly after the work is done so NOW doesn't work.
I uses a significant DB program (from a SQL platform I think)recently that had a date picker with start time and end time. Access and Excel both advertise a "Date/Time" format.
Must be false advertising.