How do I set the Time format and value of a cell?

[prateek-singh-3]

Hello,

I am trying to set the format of a cell which contains time to HH:mm and value to HH:mm:ss and am using the below code to achieve this.

Set the value:
worksheet.Cell(row, pos + 2).SetValue(dday.Equals(string.Empty) ? string.Empty : ddayTime.Value.ToString("HH:mm:ss"));

Set the format:
worksheet.Cell(row, pos + 2).Style.DateFormat.SetFormat(XLPredefinedFormat.DateTime.Hour24Minutes.ToString());
worksheet.Cell(row, pos + 2).Style.DateFormat.Format = "HH:mm";

However the final value and format in the generated excel file are both "HH:mm:ss".
It was working fine with version 0.94.2 but stopped working after upgrading to 0.102.1

Any suggestions?