Time Separators

[Colin Weir]

Hi there

Is it possible to have excel set to recognise a full stop as a time
separator or does it always have to be a colon?

Thanks

Colin

 

[Pete_UK]

Can you give a bit more information as to what you are trying to do?

Pete

 

[Colin Weir]

I would like to be able to type in either 17.30 or 1730 as a pose to
17:30.

Thanks

Colin

 

[Pete_UK]

Colin,

Check out Chip Pearson's site, here:

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

Hope this helps.

Pete