how to subtract time ?

[Divya Manoharan]

12/28/2016	11:14
12/27/2016	11:15

<colgroup><col span="2"></colgroup><tbody>
</tbody>

how to subract time if time and date are given in different cells

 

[AhoyNC]

Format cell as [h]:mm

Excel Workbook
	A	B	C	D
1	12/28/2016	11:14	*	23:59
2	12/27/2016	11:15	*	*
Sheet

 

[Divya Manoharan]

but when the days increase I get only hours calculated

22-Nov-16

20:34

<tbody>
</tbody>

24-Nov-16

16:00

<tbody>
</tbody>

the ans i get though this function is 19 hours

 

[Dave Patton]

Custom format the result [hh]:mm