Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time | Excel Worksheet Functions | |||
Adding Time | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |