Calculating total work week hours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have done a time sheet in excell. the columns are Employee name, Time in,
Time out, Total Hours,- 30 Minute lunch,total hours worked for the day. I am
now trying to total the number of hours worked for this employee for the
week. I did auto sum but the number will not go past 24. How can i get this
total for the week



Thanks
Louise
 
Hi Louise

Format the cell with the summation formula Format>cells>Number>Custom [h]:mm

Regards

Roger Govier
 
Number will in fact go beyond 24 but the display will not if you use default
time format, use custom format and instead of hh:mm use [hh]:mm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Calculating a colmun to total a 40 hour work week 3
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
TIME CALCULATION 5
Function to calculate total hours worked in one week. 4
Time Sheet Summary 1
Total Working hours If 2

Back
Top