Using Excel but can't get hh:mm to go negative when subtracted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to monitor hours worked vs hours planned eg planned 37 hours, worked
36 hours therefore want -1 hour ..... Help driving me mad
 
You won't get it.

You can get 1 by using

ABS(time_1-time_2)

and test if time_2 is greater than time_1 to prefix with a -, but this then
becomes text

=IF(time_2>time_1,"-","")&ABS(time_1-time_2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Adding Time Values Together 2
Formula to subtract a negative amount 2
Add/Subtract hours 3
Overtime Calculation 2
Subtracting Date/Time 4
subtract the time difference from another time difference 3
Displaying negative time 8
What formula can excel xp calculate hours worked ie 2145 to 0600. 1

Back
Top