View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default How do I calculate hours worked on 3rd shift?

check contexture's or chip pearson's page

http://www.contextures.com/xlfaqDat.html

http://www.cpearson.com/excel/datearith.htm

--


Gary


"Steve" wrote in message
...
How do you set up a calculation to compute hours when the shift goes from
11:
p.m. to 7: a.m. Normal calculations won't work in this case.