Hi. I am using JXL to read an Excel file using
Java.
One of the columns on the file is in a Time Format.
What is displayed in the Excel cell is (24-hr format): 0:01
When I highlight the cell, the value is different in the formula bar. It reads 12:01:00 AM
Using the code:
sheet.getCell(7,i).getContents()
returns a value of 12:01
My problem is, using the value extracted, there is no way for me know if 12:01 is AM or PM.
How can I extract the value from excel getting the displayed value? the 0:01.
or, how can I extract the value, that I can get the AM/PM?
Please advice. thank you.