Hi Louise

Format the cell with the summation formula FormatcellsNumberCustom [h]:mm

Regards

Roger Govier


Harley mom wrote:
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