Hi,

I have a cell which is formatted to "04:30 PM" but need it to read like a
24hr clock,(ie 16:00) I've tried (re)formatting it using 'number-time-type'
but with no joy. Is there a formula which can convert please?

Thanks in advance,

AW