adding time
 

I am just learning how to add time but I need to add time from pm to am.
When I do the basic formula, it obviously gives me a negative number. Is
there a different formula so i can have a positive answer. Please help. I
am using Microsoft Excel 2003

adding time
 

If you are ADDING, then it won't give a negative number. If you are
SUBTRACTING, then you may need to change =B1-A1 to either
=MOD(B1-A1,1) or
=(B1-A1)+(B1<A1)
--
David Biddulph

"GrayC011182" wrote in message
...
I am just learning how to add time but I need to add time from pm to am.
When I do the basic formula, it obviously gives me a negative number. Is
there a different formula so i can have a positive answer. Please help.
I
am using Microsoft Excel 2003

adding time
 

What is the basic formula?

If I add time I never get a negative result, only if I subtract

If you meant that you subtract end_time minus start_time then you can use

=End-Start+(End<Start)

or

=MOD(End-Start,1)



--
Regards,

Peo Sjoblom


"GrayC011182" wrote in message
...
I am just learning how to add time but I need to add time from pm to am.
When I do the basic formula, it obviously gives me a negative number. Is
there a different formula so i can have a positive answer. Please help.
I
am using Microsoft Excel 2003