Time Format solution required

[hsandeep]

How to get E2 & F2?

E2=B2-C2 (C2 is in minutes)
F2=E2+D2 (D2 is in minutes)

B2 is in MM/DD/YY format.

Sheet1

	B	C	D	E	F
2	6/11/15 9:30 AM	15	4	6/11/15 9:15 AM	6/11/15 9:19 AM

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 108px"><col style="WIDTH: 45px"><col style="WIDTH: 44px"><col style="WIDTH: 108px"><col style="WIDTH: 108px"></colgroup><tbody>
</tbody>

 

[shg]

Row\Col	B​	C​	D​	E​	F​
2​	06/11/2015 09:30​	15​	4​	06/11/2015 09:15​	06/11/2015 09:19​
3​				E2: =B2 - C2/1440	F2: =E2 + D2/1440

 

[hsandeep]

3​

E2: =B2 - C2/1440

F2: =E2 + D2/1440

<tbody>
</tbody>

[/QUOTE]

It WORKS. Please tell what is/why used 1440?

 

[shg]

In Excel serial date/time values, whole numbers are dates starting from 1/0/1900, and fractions are times.

1440 is the number of minutes in a day.