**Finding the sum of multiple time intervals**

[Soulja Boy]

I am making a schedule for my business and i need to figure out the total
amount in hours that each employee works. While I tried to do this I had
trouble entering the intervals (ie. 10am to 6 pm), and finding the sum of
them(ie. Monday to Friday)
-thankyou

 

[FSt1]

hi
to calculate time, you must have a basic understanding of how excel keeps
date/time. mathmaticly time is keep as a decimal value of 1 day. 12 hours =
..5 day

see these sites for more details plus tips, tricks, templates.
http://j-walk.com/ss/excel/files/timesht.htm
http://www.cpearson.com/excel/overtime.htm
http://www.cpearson.com/excel/DateTimeEntry.htm
http://www.xldynamic.com/source/xld.XtraTime.html
http://www.mvps.org/dmcritchie/excel/datetime.htm

regards
FSt1

 

[daddylonglegs]

In it's simplest form, start time in A2, end time in B2 use this formula in C2

=MOD(B2-A2,1)

then to calculate the sum for the week, assuming 7 days, use this formula in
C10

=SUM(C2:C8)

format C10 as [h]:mm, square brackets essential.....