Military Time

[dparkerl]

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.

 

[Gordon]

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.

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.

 

[JE McGimpsey]

you could instead input

4:30 p

for 4:40 pm