title: TimeSpan Datatype in not getting correct time while exporting to Excel
body: <p>I've created a small project where I'm using TimeSpan Datatype and I am trying to get login and logout times, but when exporting to excel, the time is not displaying in the excel column.</p>
  
  <p>Please help me.</p>
  
  <p>This is the Code where I use timespan:</p>
  
  <pre><code>public TimeSpan PunchIn { get; set; }
  
  [NotMapped]
  public string Month
  {
      get
      {
          var In = TimeZoneInfo.ConvertTimeFromUtc(PunchDate.Date + PunchIn,
              TimeZoneInfo.FindSystemTimeZoneById(User.RegisteredTimeZone));
          return In.ToString("MMMM");
      }
  }
  </code></pre>
  
  <p>And this is the kendo grid code:</p>
  
  <pre><code>@(Html.Kendo().Grid(Model)
        .Name("TimeTrackingLogsGrid")
        .Columns(columns =&gt;
        {
            columns.Bound(c =&gt; c.Id).Hidden(true).HtmlAttributes(new {style="text-align:center;"});
            columns.Bound(c =&gt; c.IsDeleted).Hidden(true);
            columns.Bound(c =&gt; c.ApprovalRequired).Visible((bool)ViewBag.IsAdmin).ClientTemplate("# if (ApprovalRequired == true &amp;&amp; Approved == false &amp;&amp; '"+ (ViewBag.IsAdmin).ToString() + "'=== 'True') {# Yes: &lt;a data-ajax='true' data-ajax-complete='refreshGrid' data-ajax-method='POST' href='/Punch/Approve/#:Id#' class='grid-link' &gt;Approve&lt;/a&gt;#} else{# No #}#");
            columns.Bound(c =&gt; c.EmployeeName).Filterable(ftb =&gt; ftb.Multi(true).Search(true));
            columns.Bound(c =&gt; c.Month).Hidden(true).Filterable(ftb =&gt; ftb.Multi(true));
            columns.Bound(c =&gt; c.PunchDate)
                .ClientFooterTemplate("#= getFormattdDate(data.PunchDate.min) # - #= getFormattdDate(data.PunchDate.max) # ")
                .ClientGroupHeaderTemplate("#:convetUtcDateToLocalDate(PunchDate)#").HtmlAttributes(new { @class = "utc-date", utc_date_value = "#:PunchDate#" });
            columns.Bound(c =&gt; c.PunchInPic).Hidden(true).Visible((bool)ViewBag.IsAdmin).ClientTemplate("&lt;img class='punchPic' width='100' src='data: image / png; base64,#:PunchInPic#'/&gt;").HtmlAttributes(new { style="text-align:center;"});
            columns.Bound(c =&gt; c.PunchIn).Groupable(false).Filterable(false).ClientTemplate("#:PunchIn.Hours#:#:PunchIn.Minutes#").HtmlAttributes(new { @class = "utc-time", utc_time_value = "#:PunchIn.Hours#:#:PunchIn.Minutes#" });
            columns.Bound(c =&gt; c.PunchOutPic).Hidden(true).Visible((bool)ViewBag.IsAdmin).ClientTemplate("&lt;img class='punchPic' width='100' src='data: image / png; base64,#:PunchOutPic#'/&gt;").HtmlAttributes(new { style = "text-align:center;" });
            columns.Bound(c =&gt; c.PunchOut).Groupable(false).Filterable(false).ClientTemplate("#:PunchOut == null ? 0 :PunchOut.Hours #:#: PunchOut == null ? 0 : PunchOut.Minutes  #").HtmlAttributes(new {@class= "utc-time", utc_time_value = "#: PunchOut == null ? 0 : PunchOut.Hours#:#:PunchOut == null ? 0 : PunchOut.Minutes #" });
            columns.Bound(c =&gt; c.Duration).Groupable(false).Filterable(false)
                .ClientFooterTemplate("#= SecondsToTime(data.DurationInSeconds.sum) # ")
                .ClientTemplate("#:formatDuration(Duration.Hours,Duration.Minutes) #").HtmlAttributes(new { @class = "" });
            columns.Bound(c =&gt; c.Comments).Visible((bool)ViewBag.IsAdmin).Filterable(false).Groupable(false).ClientTemplate("# if (ApprovalRequired == true &amp;&amp; Approved == false &amp;&amp; '" + (ViewBag.IsAdmin).ToString() + "' !== 'True') {# Please get this time log approved #} else{#&lt;span class='comments' (#:Comments# == null ? '' : title='&lt;ul&gt;  #:Comments# &lt;/ul&gt;')&gt; view &lt;span&gt;#}#");
            columns.Command(command =&gt;
            {
                //    command.Edit().Text(" ");
                command.Destroy().Text(" ");
            }).Width(50);
        })
        .HtmlAttributes(new { @class = "full-screen-dashboard" })
        //.Scrollable()
        .Groupable()
        .Sortable()
        .Filterable()
        .Navigatable()
        .ColumnMenu()
        .ToolBar(toolbar =&gt; {
            //toolbar.Create();
            //toolbar.Save();
            toolbar.Pdf();
            toolbar.Excel();
            toolbar.Custom().Text("Clear Filter").HtmlAttributes(new { @class= "clearGridFilter"  });
        })
  
        .Excel(exl=&gt;exl.AllPages(true).Filterable(true).FileName("Timesheet.xlsx")
            .ProxyURL(Url.Action("ExportSave", "Punch")))
  </code></pre>