employee hour sheet

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

Guest

I have created a spread sheet to calculate employee hours. I am able to get the total of hours for each given day but am unable to find the total hours for the work week. I have set it up as follows

Bo
Monday IN 7:00AM
OUT 5:36P
total 10:3
Tuesday IN 6:45A
OUT 5:24P
total 9:3
ETC
How do I add the hours from each day to get a weekly total?
 
Just use SUM, and format the cell as [hh]:mm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

daisy said:
I have created a spread sheet to calculate employee hours. I am able to
Click to expand...
get the total of hours for each given day but am unable to find the total
hours for the work week. I have set it up as follows:
Bob
Monday IN 7:00AM
OUT 5:36PM
total 10:36
Tuesday IN 6:45AM
OUT 5:24PM
total 9:39
ETC.
How do I add the hours from
Click to expand...
each day to get a weekly total?
 
Back
Top