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

<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>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]6/11/15 9:30 AM[/TD]
[TD="bgcolor: #ffff00, align: right"]15[/TD]
[TD="bgcolor: #99cc00, align: right"]4[/TD]
[TD="bgcolor: #ffff00, align: right"]6/11/15 9:15 AM[/TD]
[TD="bgcolor: #99cc00, align: right"]6/11/15 9:19 AM[/TD]

</tbody>

 

[shg]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][/tr][tr][td]

2​

[/td][td]

06/11/2015 09:30​

[/td][td]

15​

[/td][td]

4​

[/td][td]

06/11/2015 09:15​

[/td][td]

06/11/2015 09:19​

[/td][/tr]
[tr][td]

3​

[/td][td][/td][td][/td][td][/td][td]E2: =B2 - C2/1440[/td][td]F2: =E2 + D2/1440[/td][/tr]
[/table]

 

[hsandeep]

[TABLE="class: grid"]
<tbody>[TR]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]E2: =B2 - C2/1440[/TD]
[TD]F2: =E2 + D2/1440[/TD]
[/TR]
</tbody>[/TABLE]
[/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.