Start time =A1
End time = B1

Try:-

=(B1-A1+(B1<A1))*24

Mike

"DonElston" wrote:

We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.