Customise cell format to display 09:00 - 17:00

Hi,

Nice and quick question.

I have a list of shifts in a spreadsheet but the layout changes depending on cell. I would like the format to display the data as 00:00 - 00:00.

Eg - Some shifts are displayed as 00.00-00.00 so would need to change. Is there a way i can format the whole column to display the data in this way?

Thanks

Chris

Originally Posted by royUK

Just click on the Header letter to select the whole column, then apply your Format

How do i apply the format?

Originally Posted by royUK

Right Click after selecting the cells. Choose Format cells ->Number -> Custom. Then create the Format you want, usually find the nearest one in the lis & adapt it

How do you adapt it? ideally need the code to put in custom box.

Thanks

Chris