Trying to figure out IF formula

[jpc99]

A B C D
Dispatched Ambulance On Scene Other Resource On Scene Elapsed

1 6:35:39 6:42:36 =IF(B1,<>"",B1-A1) IF(B1,"",C1-A1)
2 6:42:45 6:55:51
3 6:55:59 6:56:31
4 6:59:26 7:07:44
5 7:18:44 7:32:18


I am trying to get an elapsed time by subtracting the time in column A from the time in column B unless column B is blank in which case subtract column A from column C. I'm not sure of the correct nomenclature for the formula but have tried several different iterations without success. I know the one above is not close, just trying to show what I'm trying to do

[Fluff13]

Hi & welcome to the board.
How about
=IF(B1,<>"",B1-A1,C1-A1)

[hemesh]

try using in D1
=if(B1<>"",B1-A1,C1-A1)

[Pete_UK]

The general form of an If statement is:

=IF( some_condtiion , action_if_true , action_if_false )

so try this instead of your formula:

=IF(B1="" , C1-A1 , B1-A1)

It is hard to see from what you have posted which columns the data sits in, so it is always better to post a sample workbook (see the yellow banner at the top of the screen).

Hope this helps.

Pete

[jpc99]

That worked. Thanks for you help. Sorry about the columns in the question and thanks for the advice for next time.

[Fluff13]

You're welcome & thanks for the feedback

[hemesh]

thanks for the feedback :-)

[hrlngrv]

. . . I am trying to get an elapsed time by subtracting the time in column A from the time in column B unless column B is blank in which case subtract column A from column C. . . .

While there are tabs in your post, this web site follows web standards and replaces all whitespace sequences with single spaces, so your posting is difficult to read. There is a formatting option for tables, but convention here is to post example workbooks. That'd help.

If there's no time in either cols B or C, presumably you'd want a blank result. Also, I figure you could have instances of dispatch time just before midnight and on scene times just after midnight.

D1: =IF(COUNT(B1),MOD(B1-A1,1),IF(COUNT(C1),MOD(C1-A1,1),""))

Note: this only works when elapsed times are less than 24 hours/full days due to the MOD call. However, if you could have elapsed times greater than 24 hours, you should be using date along with time.