Options

Import Time Value from Excel

elkarmoelkarmo Member Posts: 5
Hi all, i'm serching for a solution for import the time value from an excel workbook...
I had try to use the VARIANT2TIME, but it want that the value is a Date,Time...
My field is only time value....
You can help me, please???
Thanks....

Comments

  • ara3nara3n Member Posts: 9,258
    did you try evaluate(mytime,cell.value)?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • krikikriki Member, Moderator Posts: 9,120
    Or EVALUATE(mytime,FORMAT(cell.value))
    The second parameter of EVALUATE should be a text, so maybe it is necessary to FORMAT the variant-value.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.