| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract times and let result go negative
Total hours available less hours worked each day, allow results to go
negative. Excel displays negative times as #. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract times and let result go negative
You can generate negative times if you use the 1904 date system Tools Options Calculation 1904 date system ....although if you use on an existing worksheet it'll make all your dates 4 years later! -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=509527 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
