WallyWumpus
27th Nov 2009, 13:39
Hi all,
I am trying to create a spreadsheet to help me with my roster each month.
I have a spreadsheet which has times in the following format: hh:mm Z eg: 20:30 Z
In order to be able to manipulate these as true times, I would love to be able to truncate the values to just hh:mm, and get rid of the Zulu letter.
Could anyone suggest a formula to do just that?
Thanks in advance
Wally.
I am trying to create a spreadsheet to help me with my roster each month.
I have a spreadsheet which has times in the following format: hh:mm Z eg: 20:30 Z
In order to be able to manipulate these as true times, I would love to be able to truncate the values to just hh:mm, and get rid of the Zulu letter.
Could anyone suggest a formula to do just that?
Thanks in advance
Wally.