Military Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dparkerl - 29 Sep 2004 19:24 GMT

how can i key 4:30 and mean 4:30 pm. thanks

Gordon Wrote:

> "dparkerl" <dparkerl.1dcram@excelforum-nospam.com> wrote in message
> news:dparkerl.1dcram@excelforum-nospam.com...
> >
> > I am trying to use this formula (=MIN((G10-C10)-(F10-D10),10/24). It
> is
> > giveing the coreect time but I can't input time as 7:00(A1) 4:30
> (A2).
> > I have to key 7:00 16:30.
> >
> > --
> > dparkerl
> >
> ------------------------------------------------------------------------
> > dparkerl's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=14840
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=264686
>
> 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.

Signature

dparkerl

Reply to this Message

Gordon - 29 Sep 2004 19:50 GMT

dparkerl cogitated deeply and scribbled thusly:

> how can i key 4:30 and mean 4:30 pm. thanks

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

Reply to this Message