Thread: TimeSheet calculatons Overnights
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default TimeSheet calculatons Overnights
=MOD(B1-A1,1)
or
=(B1-A1)+(A1B1)

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


Reply With QuoteReply With Quote