Solved

Negative Time

Posted on 2001-06-26
2
683 Views
Last Modified: 2008-03-04
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.
0
Comment
Question by:dken
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
sbereli earned 100 total points
ID: 6227235
Hi,dken!
 There is absolute no problem with negative time in Access, and moreover in Excel. You just must set Number Attributes of cell in Excel to Date/Time, or for instanse General Numeric (it will be ok either).

Best Regards,

Bernstein Eli.
0
 

Author Comment

by:dken
ID: 6321733
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
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question