ExcelBanter - Entering and displaying time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Entering and displaying time (https://www.excelbanter.com/excel-discussion-misc-queries/261535-entering-displaying-time.html)

jdj420

Entering and displaying time

I want to know if there is a way to enter the value of a cell as (for
example) 2330 and it display as 23:30?

Jim Thomlinson

Entering and displaying time

Check ou tthis link. I have used variations of this very successfully...

http://www.cpearson.com/excel/DateTimeEntry.htm
--
HTH...

Jim Thomlinson

"jdj420" wrote:

I want to know if there is a way to enter the value of a cell as (for
example) 2330 and it display as 23:30?

All times are GMT +1. The time now is 09:40 AM.