calculating hours in one cell

[Guest]

i am new to excel, i am trying to make a spread sheet for a weekly schedule
that will calculate the hours that will be worked for the week. for example:
Name Monday Tuesday Wed Thurs Fri Sat Sun
Total
Jon 9 to 5 12 to 5 off 9 to 5 off
off 12 to 6 27

I want the spread sheet to calculate the total hrs per day and then to add
up all the days and to total it for me. Please help i am clueless. Thanks!

 

[Biff]

Hi!

You need to enter the time as a TIME and use 2 cells, one for START (or IN)
and one for END (or OUT):

B3 = Start = 9:00 AM
C3 = End = 5:00 PM
D3 = Daily Total = formula:

=IF(COUNT(B3:C3)<2,"",C3-B3+(C3<B3))

Format the cell as [h]:mm

Returns 8:00

If a person is OFF just leave the cell empty. No real need to enter OFF.
Besides, if you enter OFF you'll have to use a different formula.

To get the weekly total just sum all the daily total cells:

=SUM(D3,G3,J3,etc....)

Also format that cell as [h]:mm

Biff

 

[Biff]

Hi!

You need to enter the time as a TIME and use 2 cells, one for START (or IN)
and one for END (or OUT):

B3 = Start = 9:00 AM
C3 = End = 5:00 PM
D3 = Daily Total = formula:

=IF(COUNT(B3:C3)<2,"",C3-B3+(C3<B3))

Format the cell as [h]:mm

Returns 8:00

If a person is OFF just leave the cell empty. No real need to enter OFF.
Besides, if you enter OFF you'll have to use a different formula.

To get the weekly total just sum all the daily total cells:

=SUM(D3,G3,J3,etc....)

Also format that cell as [h]:mm

Biff