js取得excel中的日期是小数格式,比如8:15,取出来的值是0.34375,怎么转换成时间格式
http://blog.stevenlevithan.com/archives/date-time-format
function valueToTimeStr(value){
var second = value*24*60*60;
var h = Math.floor(value*24) ;
var m = (value*24 - h)*60;
var s = second - h*60*60 - m*60;
return h+":"+m+":"+s;
}
console.log(valueToTimeStr(0.343750));//8:15:0
console.log(valueToTimeStr(0));//0:0:0
console.log(valueToTimeStr(1));//24:0:0