Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i display negative time differently? | Excel Discussion (Misc queries) | |||
How do I get Excel to display a negative value for time? | Charts and Charting in Excel | |||
How do I display negative time values in excell? | Excel Worksheet Functions | |||
How do I display time in a negative format? | Excel Worksheet Functions | |||
What is the formula to display a negative time results? | Excel Worksheet Functions |