View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Help with calculating time and a half - I've got straight time and double time.

Errata.... I wrote:
"Paxton31" wrote:
F2: =MIN(8,(C2-B2+E2-D2)*24)
G2: =MIN(4,(C2-B2+E2-D2)*24 - F2)
H2: =(C2-B2+E2-D2)*24 - F2 - G2

Note: I assume that B2, C2, D2 and E2 have date and time, or midnight
does occur between B2 and C2 or between D2 and E2. Right?


I meant to write: "or midnight does __not__ occur between" the time-in and
time-out times.

The point is: if the cells contain only time and the shift spans midnight,
the calculations will not be correct. But it is consistent with your
original calculations.