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

Format cell as h:mm


"Putts" wrote:

Can I have a formula in Excel for a person starting work at 7pm monday and
finishing work at 9am Tuesday - the result should be 14 hours worked but it
comes up -10?
Reply With QuoteReply With Quote