Thread: How do i display a negative time as a res of distracting 2 times?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default How do i display a negative time as a res of distracting 2 times?
If you can settle for a text result,

=IF(A2-A1<0,"-","")&TEXT(ABS(A2-A1),"hh:mm")

HTH
Kostis Vezerides

On Jul 12, 8:56 pm, Red Bullit <Red
wrote:
In a sheet about working time i want to extract two times.
1 is the normal working hours for the day
2 is the actual worked hours on a day
If 2 < 1, the result is negative - I worked not enough hours on that day.
The result is displayed as ######.

Question:
Is it posible to display negative hours c.q. times in a sheet?


Reply With QuoteReply With Quote