<div>
I passed your solution on to the user who raised the question, since I've heard nothing back from him, I assume your solution was correct. Thankyou, and my apologies for the delay.<br />
<br />
dken
</div>


I passed your solution on to the user who raised the question, since I've heard nothing back from him, I assume your solution was correct. Thankyou, and my apologies for the delay.

dken

<div>
<div class="content wysiwyg-content">
I need to calculate time differences in the negative. ie in a working day if you are due to work 8 hours and you work 7, then I need to display -1. This is for flexy time calculations. <br />
I'm using Access 97 but would also like to know how to do this in Excel 97. I've got it to work +ve times ok in excel.
</div>
</div>


I need to calculate time differences in the negative. ie in a working day if you are due to work 8 hours and you work 7, then I need to display -1. This is for flexy time calculations. 
I'm using Access 97 but would also like to know how to do this in Excel 97. I've got it to work +ve times ok in excel.

Negative Time

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.