D dparkerl Sep 29, 2004 #1 how can i key 4:30 and mean 4:30 pm. thanks That's correct - Excel will take 4:30 as 4:30AM. And please, as you are posting from the Excel Forum, which is replicating this newsgroup, quote the post you are replying to. Thank you. Click to expand...
how can i key 4:30 and mean 4:30 pm. thanks That's correct - Excel will take 4:30 as 4:30AM. And please, as you are posting from the Excel Forum, which is replicating this newsgroup, quote the post you are replying to. Thank you. Click to expand...
G Gordon Sep 29, 2004 #2 dparkerl cogitated deeply and scribbled thusly: how can i key 4:30 and mean 4:30 pm. thanks Click to expand... You can't - you have to key in 16:30. You CAN format the cell however so that it SHOWS 4:30 PM, but you still have to key in 16:30
dparkerl cogitated deeply and scribbled thusly: how can i key 4:30 and mean 4:30 pm. thanks Click to expand... You can't - you have to key in 16:30. You CAN format the cell however so that it SHOWS 4:30 PM, but you still have to key in 16:30
