Hi,
Is there a way to convert an AM time value to PM with a formula ?
I have a list of time values such as
12:21:12
08:10:10
etc
etc
but some of them are AM and others are PM. I want to convert them to a 24 hour clock but can't. By formatting alone I haven't managed to achieve it so I was wondering if there a formula that could do it. I can apply the formula to the PM only and convert them to a 24 hour time value.
Thank you in advance for any feedback,
K.
Bookmarks