| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding time
"Sandy Mann" wrote in message
... Thanks for sharing that Bruno, It also returns 24:00 if both cells are blank, if that is a problem then you could add another test: =A2-A1+(A2<=A1)*(A1<"") Or =(A2-A1+(A2<=A1))*AND(A1<"",A2<"") Ciao Bruno |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formula for adding up time intervals? | Excel Discussion (Misc queries) | |||
| Help with Adding Time Hrs and Mins | Excel Discussion (Misc queries) | |||
| Adding time | New Users to Excel | |||
| adding in time formats | Excel Discussion (Misc queries) | |||
| Adding time to multiple cells using TIMECODE | Excel Discussion (Misc queries) | |||
Threaded Mode
