how do i add up time to total hours?

[CRGHTNSOCR]

in b8 i have time in as 8:00 am and in c8 i have time out as 4:00 pm.
how do i set it up where it will calculate total hours worked?

i would like to be able to add up the entire week, so i tells me th
total for the week and not just the day.

i need it to add b8 with c8 (day 1) and d8 with e8 (day 2) and s
forth.

any help is appreciated.

thank yo

 

[Bob Phillips]

because of your layout, you will have to do

=(c8-b8)+(e8-d8)+ ...

or

=SUM(c8,e8,...)-SUM(b8,d8,...)

make sure you format your result cell as [h]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gary Brown]

=(c8-b8)*24

=sum(b8:b14)

HTH,
Gary Brown