3 Replies Latest reply: May 15, 2014 9:56 AM by Data Kruncher RSS

    Excel format question

    Bradl Vogl

      Can anyone be of assistance?

       

      I have a Time Span field that I want to export to Excel.

       

      (Monarch Sample)

      Time

      00:00:36

      03:16:34

      00:05:45

      00:00:36

       

      (Results in Excel)

       

      Time

      36

      11794

      345

      36

       

      I have tried to format the Excel cells as hh:mm:ss and it comes up with 00:00:00 for all.

      I tried to copy and paste from Monarch to Excel with the same results.

       

      Can someone suggest a solution?

       

      I Appreciate any help.

       

      Thanks,

      Brad Vogl