inserting 24 hr time anytime

[sam__gleeson]

I require 24 hour time to be formatted in cell D11. What happens is the actual time may not get entered until later on

Example: The current time is say 13:30 but i need to enter the actual time achieved which was 10:30 in D11

What is the easiest way to achieve as i want 24 hour displayed

Thank you

Sam

 

[Dryver14]

Can you explain further as at the moment all you have to do is type 10:30 into the cell.

 

[sam__gleeson]

Sorry i had a type error at my end

 

[Dryver14]

As long as you are sorted