Adding negative and positive times

C

Chrisb

Hi can anybody help?

I'm trying to find the sum of three times two positive, one negative

The formula I'm using is

=TEXT(G35+E36-F35,"[h]:mm") E36 being the negative time.

all it gives me is a #VALUE! error
 

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

Problem with formula for finding last greater than/less than or equal to value 2
Negative value to positive 13
How to sum negative times 2
Goal Seeking via Excel 0
How do I limit formula results to positive only? 4
subtract a positive from a negative 7
Show time as a negative figure 3
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10

Top