Thread: How do i display a negative time as a res of distracting 2 times?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Red Bullit Red Bullit is offline
external usenet poster
  
Posts: 1
Default How do i display a negative time as a res of distracting 2 times?
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