sum of hours

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

I run a small business that I need to schedule the work hours for my
employees on a sheet. A particular cell contains the hours work for a
employee from 2 am-5 Pm, 2 pm- 9pm. That were exactly what I put down.
However, I want excel to automatically add the total hours worked by each
employee in the right most colum. However, I cannot use the sum function
with the format from above. Is there a different way for me to input the
hours, so that the sum function will work, but I still want a format
similar to the once from above?

Thank You.
 
Raymond -

Allow yourself more columns. In A1 enter "Name", in B1 and D1 enter
"Time In" and in C1 and E1 enter "Time Out". Put the names in column A,
with the appropriate times in columns B to E. In F2 enter this formula:

=C2-B2+E2-D2

and give it a custom number format: select the cell, choose Cells from
the Format menu, click on the Number tab, and enter a custom one with
this format:

[h]:mm

THis gives you a running sum of hours and minutes, without AM or PM, and
without starting again at 24 hours. copy this cell down column F as far
as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top