=MOD(E7-D7,1)
Assume Start time is in D7 and End time in E7. Format the cell as Time

--
Regards,
Tom Ogilvy


"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.