how to convert a string date in second and minutes RRS feed

  • Question

  • Dear all,

    I am not use to VBA and I am looking at how can I convert a datetime string into a second and minutes representation.

    What I mean is that if I have :

    datetime string : 11/02/2019 12:32:45

    In second : ?

    In minutes : ?

    What is the best way to do in VBA could not find any proper method ToSecond or ToMinutes

    Thanks for help


    Thursday, April 18, 2019 11:30 AM

All replies

  • Do you want to return 45 for seconds and 32 for minutes? If not, please explain what the result should be.

    Regards, Hans Vogelaar (

    Thursday, April 18, 2019 1:13 PM