Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding times
I am using the following formula to add times (24 hour) in MS Excel 2003
=IF(J<I,J+1-I,J-I) . I is my start time J is my finish time. The formula works ok when a start and finish time are entered but if ONLY a start time or finish time are entered the "total hours" cell is populated with incorrect data. Is there any way I can say"if either I or J are empty then "total Hours = 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADDING TIMES | Excel Worksheet Functions | |||
Adding times | New Users to Excel | |||
adding times together | Excel Discussion (Misc queries) | |||
Adding up Times | Excel Worksheet Functions | |||
Adding times | Excel Worksheet Functions |