Difference between to date and time together please let me know

[lathish]

HERE IT IS A	B	C	D	E
Order #	Order Date	Manifested date	City	Delivered
OR3173JG-002A	27-11-2017 17:25	01-12-2017 12:24	Mysore	04-12-2017 13:46
OR3289CG-002A	28-11-2017 11:10	01-12-2017 11:00	Coimbatore	04-12-2017 14:29
OR7846FG-002A	27-11-2017 19:15	01-12-2017 10:55	Coimbatore	04-12-2017 19:38
OR5531NF-003A	28-11-2017 19:19	01-12-2017 09:53	Coimbatore	04-12-2017 20:20
OR8259UG-001A	28-11-2017 09:16	02-12-2017 12:27	Mysore	05-12-2017 10:16
OR9663UG-001A	28-11-2017 11:50	01-12-2017 17:18	Mysore	05-12-2017 10:41

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

SIR LET ME KNOW IF ANY FORMULA TO FIND DIFFERENCE BETWEEN{ B AND C }, {C AND D } IT SHOULD INCLUDE DATE AND TIME AS WELL
I TRIED TO FIND BUT I FAILED

KINDLY LET ME KNOW THE FORMULA IT WOULD BE VERY HELP FULL

 

[jtakw]

Hi,

I think you mean C and E, and your keyboard is stuck on CAPS lock, this will Only work if your values in Columns B, C, E are real Date/Time values:

Book1
	A	B	C	D	E	F	G	H
1	Order #	Order Date	Manifested date	City	Delivered		Order to Manifest Date	Manifest to Delivered Date
2	OR3173JG-002A	27-11-2017 17:25	01-12-2017 12:24	Mysore	04-12-2017 13:46		03 18:59	03 01:22
3	OR3289CG-002A	28-11-2017 11:10	01-12-2017 11:00	Coimbatore	04-12-2017 14:29		02 23:50	03 03:29
Sheet1

Cell Formulas
Range	Formula
G2	=C2-B2
H2	=E2-C2

 

[lathish]

is any other way to calculate coz i tried but it comes in normal subtraction way kindly help

 

[Joe4]

What do jtakw's formulas return when you try them on the sample data you posted?