Thread: I want to get negative hours if subtraction of hours is negative
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default I want to get negative hours if subtraction of hours is negative
You can't do that but there is a workaround by displaying the negative time
in minutes. Try the formula:-

=(C2-D2)*24*60

"hema" wrote:


A B C
D E
1 In Time Out time Actual hours Working hours
2 9:00 17:00 8:00
8:45 =C2-D2

In the E2 cell i am getting only ####,here i want to get the negative hours



Reply With QuoteReply With Quote