Schedule

  • Thread starter Thread starter Biff
  • Start date Start date
B

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
 
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?
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top