Negative saldo when comparing hours

  • Thread starter Thread starter joel
  • Start date Start date
J

joel

Good afternoon,
Could somebody help me with a little worry
I want to calculate a negative time difference
like 09:15 minus 10:00 equal to -00:45 minutes
Excel gives me a funny railroad !
Do you have any idea ?
Thanks in advance
Joël
 
Assuming 09:15 is in A1, 10:00 in B1

Maybe try:

=IF(A1<B1,"-"&TEXT(ABS(A1-B1),"hh:mm"),TEXT(A1-B1,"hh:mm"))

which will give the answer as text

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---
Good afternoon,
Could somebody help me with a little worry
I want to calculate a negative time difference
like 09:15 minus 10:00 equal to -00:45 minutes
Excel gives me a funny railroad !
Do you have any idea ?
Thanks in advance
Joël
 
Joel,

Why do you want to show negative times, is it because you want to further
calculations based upon it? If so, I would suggest it is easier to use
decimal hours, for instance

=(A1-B1)*24

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Good afternoon,
Could somebody help me with a little worry
I want to calculate a negative time difference
like 09:15 minus 10:00 equal to -00:45 minutes
Excel gives me a funny railroad !
Do you have any idea ?
Thanks in advance
Joël
 
Hi Joel!

The 1904 date system allows negative times:

Tools > Options > Calculation
Check 1904 date system

It's workbook specific and you can't mix and match in the same
workbook. My inclination would be to convert the times to numbers of
hours or minutes and to work with them.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Good afternoon,
Could somebody help me with a little worry
I want to calculate a negative time difference
like 09:15 minus 10:00 equal to -00:45 minutes
Excel gives me a funny railroad !
Do you have any idea ?
Thanks in advance
Joël
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time - Hours and Minutes 4
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Summing negative time 8
filling in time in hours and minutes 2
How many are at work every hour in a 24-hour day? 2
sum field is zero when using Pivot table 1
Adding a decimal hours to a starting time to give a finishing tim 3
Calculate time worked based on start / end times & working hours 3

Back
Top