Schedule

[Biff]

Hi John,

Here's one way:

Start time is in A2. End time is in B2.

=IF(B2-A2+(B2<A2)>=0.25,B2-A2+(B2<A2)-30/1440,B2-A2+
(B2<A2))

This handles any times that roll past 12 AM. Format cell
as [H]:mm

Biff

 

[John]

Biff,

Thanks so much for both pieces of info.

John

-----Original Message-----
John,

You can also check out this site for an example file
available as a free download.

http://j-walk.com/ss/excel/files/timesht.htm

Biff

-----Original Message-----
Hi John,

Here's one way:

Start time is in A2. End time is in B2.

=IF(B2-A2+(B2<A2)>=0.25,B2-A2+(B2<A2)-30/1440,B2-A2+
(B2<A2))

This handles any times that roll past 12 AM. Format cell
as [H]:mm

Biff

-----Original Message-----
I have a simple schedule for 5 employees. When I enter the
hours to be worked (9am-5pm), I want a formula that will
calculate the numbers of hours worked.

Also, if a shift is >= to 6 hours, I want to subtract .5
hours for lunch.

Can anyone help?
.

.

.