excel spreadsheet- work schedule

  • Thread starter Thread starter conrad guerra
  • Start date Start date
C

conrad guerra

Hello,
I have a question, I have a shedule I made in an Excel
spreadsheet, I have someone working from say 9:00am to
1:00pm one day and another day from1:15 pm to 6:00pm, and
so forth throughout a 6 day work week, how can do a
formula at the end to add up the hours for the six days.

I really appreciate you guys help

Thanks a bunch
 
Hi
one way: assumption: col. A stores your starting time and column B your
ending time
- enter the following in C1
=B1-A1
if the working time can span midnight use
=B1-A1+(B1<A1)

copy either of these formulas down for all 6 days
To sum these values use
=SUM(C1:C6)
and format this cell (goto 'Format - Cells') with the custom format
[hh]:mm

you may also have a look at
http://www.cpearson.com/excel/datetime.htm
for more information
 
Back
Top