Skip to content
Advertisement

Kendo Spreadsheet Convert time to decimal while parsing the row values

I was trying to save the kendo spreadsheet data with js. while parsing the row value I saw the kendo spreadsheet convert the date to numbers and time to decimal. I’ve converted the number to date using moment js but can’t convert the decimal number to the exact time. how to convert that or it would be nice if I can get the date and time as shown in the spreadsheet meant only string. below is the sample code and screenshot.

JavaScript

see the cell number format and value see the cell format

enter image description here here are the date and time fields

Advertisement

Answer

Converted the StartTime and EndTime using the function ConvertExcelTime and momentjs.

JavaScript
User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement