Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Times
I am attempting to add my project hours in MS Excel. Column A is
start time (ex. 11:00am with "time" format), column B is stop time (ex. 2pm with "time" format). I want column C to take the difference between columns A and B and put it into Column C. For the given example, column C should be 3. It tried the following solutions: 1. = B2-A2+IF(A2B2,1) 2. = B2-A2 Additionally, when press "Enter" to compute the formula, #VALUE! appears in box. How can get the difference to come out correctly? Thanks, Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Times
Try:
=MOD(B2-A2,1) HTH " wrote: I am attempting to add my project hours in MS Excel. Column A is start time (ex. 11:00am with "time" format), column B is stop time (ex. 2pm with "time" format). I want column C to take the difference between columns A and B and put it into Column C. For the given example, column C should be 3. It tried the following solutions: 1. = B2-A2+IF(A2B2,1) 2. = B2-A2 Additionally, when press "Enter" to compute the formula, #VALUE! appears in box. How can get the difference to come out correctly? Thanks, Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Times
Check that A2 and B2 really do contain time data, rather than text
strings that just happen to look like time format - your example for B2 (2pm) doesn't look like it is correct. It might also help to change the time format to the 24-hour clock. Hope this helps. Pete On Feb 19, 4:34 pm, wrote: I am attempting to add my project hours in MS Excel. Column A is start time (ex. 11:00am with "time" format), column B is stop time (ex. 2pm with "time" format). I want column C to take the difference between columns A and B and put it into Column C. For the given example, column C should be 3. It tried the following solutions: 1. = B2-A2+IF(A2B2,1) 2. = B2-A2 Additionally, when press "Enter" to compute the formula, #VALUE! appears in box. How can get the difference to come out correctly? Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting times | Excel Discussion (Misc queries) | |||
Subtracting two times in hh:mm:ss format | Excel Discussion (Misc queries) | |||
Subtracting Times | Excel Worksheet Functions | |||
Subtracting times | Excel Discussion (Misc queries) | |||
Subtracting Times | Excel Worksheet Functions |