How do you switch from military to standard time when using the NOW() function. Im doing a spreadsheet for a class and the professor says we have to use the NOW() function and it cant be in military time. My computers regional settings are set for standard time so its not that. Any help is much appreciated...

 

Try formatting the cell using CTRL+1 (or the format menu). It's under the "Number" tab, "Time", select desired format.