| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying negative time
Hi everyone,
first time on here so hope you can help me. I use Excel (2003) for recording employee time / flexi hours. This is allowed to go into a negative but I can't seem to display this. The formula calculates fine and when the time is positive is shown in the time format (ie 15:30 etc) but when it is negative I just get #### which usually means the column needs widening but this doesn't make any difference. Any ideas anyone? Thanks -- Babs - Leicester UK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying negative [h]:mm:ss | Excel Discussion (Misc queries) | |||
| Displaying negative hh:mm:ss | Excel Discussion (Misc queries) | |||
| Displaying negative time in excel | Excel Worksheet Functions | |||
| Displaying Negative % | Excel Discussion (Misc queries) | |||
| More problems displaying a negative time | Excel Discussion (Misc queries) | |||
Threaded Mode
