Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Difficult to answer without knowing what values are actually in X1/W1 when
you are getting th 19:00 result. In the meantime, I think you can simplify your formula to: =IF(W1="","w1 empty",IF(W1<X1,X1-W1,"")) or (to put it more like yours is now) =IF(W1="","",IF(W1<X1,X1-W1,"")) "default time to PM after 12:00 pm" wrote: I'm trying to calculate the hh:mm difference between two cells and asking to do nothing if W1 is blank. Why am I getting 19:00 as a value from a calculation of: =IF(W1<X1,X1-W1,IF(W1="","",IF(W1X1,"",""))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning calculation status | Excel Worksheet Functions | |||
returning calculation based on number | Excel Worksheet Functions | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Nested If statements returning a sum calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) |