subtracts time array formula

[Vishaal]

Hi All,

Thanks in advance,

we have the following sheet, we want to subtract B3-B2 in A3,

	06-07-2020 13:16
0.002986111	06-07-2020 13:21
	06-07-2020 13:24
	06-07-2020 13:28
	06-07-2020 13:36

pls provide any array formulla

 

[ashakantasharma]

Press CTRL+SHIFT+ENTER for array formula. You can copy the formatting and use the minus formula as given below

06-07-20 13:16
06-07-20 13:21	00-01-00 0:05​
06-07-20 13:24	00-01-00 0:03​
06-07-20 13:28	00-01-00 0:04​
06-07-20 13:36	00-01-00 0:08​

 

[Vishaal]

unable to understand,

tried but not working, can you pls share the formula which you have used

 

[Vishaal]

can we use below formula

=(if(ISBLANK(A3),,B3-B2))

but i dont know how to convert it to array so that this formula can copy down

 

[CA_Punit]

Why do you need a array formula. It is just substract?
Please specify your intention

 

[Vishaal]

Thanks for your attention but we have got the solution,

we are using this

=ArrayFormula(IF(C5:C="","", C5:C-C4:C))

we need array formula, because if any row deleted, formula will auto change

 

[Vishaal]

Thanks CA-Punit

Thanks ashakantasharma

 

[CA_Punit]

Thanks for your attention but we have got the solution,

we are using this

=ArrayFormula(IF(C5:C="","", C5:C-C4:C))

we need array formula, because if any row deleted, formula will auto change

But you cannot change part of array format. Row cannot be deleted if you are using array

 

[Vishaal]

i don't know but its working fine in my case