How to convert decimal to HH:mm:ss

yukon

Hi Expert,

I export nav data to excel file. Date and time is change.
Date 03/25/06 -> 38801
Time 11:0000AM -> 0.458333333333333

When i re-import that excel file to nav. Date is not has any problem. Time is empty. :x

So how can i convert this excel decimal value to time? Please how to do it?



Best Regards,
Yukon

ayhan06

yukon wrote:

Hi Expert,

I export nav data to excel file. Date and time is change.
Date 03/25/06 -> 38801
Time 11:0000AM -> 0.458333333333333

When i re-import that excel file to nav. Date is not has any problem. Time is empty. :x

So how can i convert this excel decimal value to time? Please how to do it?



Best Regards,
Yukon

03/25/06 = "38801 or your variable" + 01011900D;( but this is 03/27/06, not 03/25/06)

11:0000AM = 0000T + ROUND(0.458333333333333 * 86400 *1000,1);

Belias

how do you export data?
if it's a routine of yours, you have to preformat the data to text, and if this does not work, add a single quotemark in front of your exported value to make it text and keep the original value.
when you reimport the value, evaluate it to time or date

yukon

Hi All,

Thx 4 your reply.

Hi Belias,
how do you export data?
if it's a routine of yours, you have to preformat the data to text, and if this does not work, add a single quotemark in front of your exported value to make it text and keep the original value.
when you reimport the value, evaluate it to time or date
how do you export data?
if it's a routine of yours, you have to preformat the data to text, and if this does not work, add a single quotemark in front of your exported value to make it text and keep the original value.
when you reimport the value, evaluate it to time or date

I downloaded our site Export/Import Excel object. And test it.

Regards,
Yukon