Convert Time into Hours in Excel

  • Can someone please help


    I have attached a section of my timesheet report that come from SICON, the report shows the hours worked in each day on different elements for each week of the month.


    When I pivot rather than show 8hrs is represents 1/3 (0.333) of a day, I would like to be able to convert the sheet into actual hours worked and pivot this.
    I need to report of the hours worked by each member of staff for the month, also hours on each project for the month.


    best regards
    Dave

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!