benjizulu
asked on
Excel: calculating with times
I have twoo fields: IS and SHOULD.
example:
07:00 - 06:00 = 01:00
07:00 - 08:00 = 01:00
-> but it should be -01:00
how can I calculate times in the correct
way ???
example:
07:00 - 06:00 = 01:00
07:00 - 08:00 = 01:00
-> but it should be -01:00
how can I calculate times in the correct
way ???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Actually if I remember right, I got "###########", not 1:00 for negative time. What version of Excel are you using? Hope the solution works for your case too.
The solution I provided should work for the following versions:
Microsoft Excel for Windows, versions 2.10c, 2.10d, 3.0, 3.0a, 4.0, 4.0a, 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 2.20, 2.2a, 3.0, 3.0a, 4.0, 5.0, 5.0a
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows
Microsoft Excel for Windows, versions 2.10c, 2.10d, 3.0, 3.0a, 4.0, 4.0a, 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 2.20, 2.2a, 3.0, 3.0a, 4.0, 5.0, 5.0a
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel 97 for Windows
benjizulu, Welcome to Experts-Exchange. I see that you are new here. I urge you that if you like the answer, accept it. If not, Add a comment as to why. What ever you do, please don't ignore the question until it is closed. Lately I have answered questions for several first-time users and they haven't been responding back.