Is there a way to export data to excel to be detected as excels format time hh:mm and [h]hh:mm

0

Hello,

When exporting to excel, i need excel to detect cell type as format hh:mm and [h]hh:mm, it's basically a time interval., so I can perform excels SUM on selected fields and get result in format [h]hh:mm.

This is possible when doing manully in excel.

My input data is also of format hh:mm.cell  type detection is turned on.

tried sending it as string, ofc excel detects that as string.

tried parsing it using

SimpleDateFormat("HH:mm").parse("15:35")

, excel detects that as date and time (something like "1/1/1970 15:35"), while I just need the time.

tried using net.sf.jasperreports.export.xls.pattern, that gives nice look of data, but nature of data in cell is still date and time.

So is there a way to export to excel and have excel cell data to be excels time hh:mm and /or [h]hh:mm format?

Thank you

kolesar.mihal's picture
Joined: Jun 10 2019 - 1:18pm
Last seen: 3 days 19 hours ago

0 Answers:

No answers yet
Feedback
randomness