I'm trying to insert the current time into a cell formatted to take the date & time where the date is omitted from the format, but the time is enabled. It's giving me 12:00 AM as the current static time. Suggestions?
Perhaps it is a bug. Wouldn't surprise me. I have a way with getting straight on a bug. Has anyone tried inserting the time into a time only formatted field using the insert menu? Do you also get 12:00 AM? It seems hard to believe such an obvious insertion could be buggy. Cheers