Forum Discussion

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Anonymous

 

Based on your sample data, what would your expected output look like?  Do you just want a table that shows Employees and then their total hour count?  Or does this need to be broken down by day?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Phil_Seamark thanks for the replay.

     

    Yes.. need to show the employees and thier total hour spent. 

    Please suggest me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Phil_Seamark expected output for the given sample data is.

       

      Emp NameOutput In Hr.Min
      A9.4
      B2.35
      C6.23
      D6.46

       

      and Yes.. need to show the employees and thier total hour spent in a daily basis.

       

      Please suggest.

       

      Thanks,

      Mohan V