Difference between to date and time together please let me know

[lathish]

[TABLE="width: 490"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]HERE IT IS
A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Order #[/TD]
[TD]Order Date[/TD]
[TD]Manifested date[/TD]
[TD]City[/TD]
[TD]Delivered[/TD]
[/TR]
[TR]
[TD]OR3173JG-002A[/TD]
[TD="align: right"]27-11-2017 17:25[/TD]
[TD="align: right"]01-12-2017 12:24[/TD]
[TD]Mysore[/TD]
[TD="align: right"]04-12-2017 13:46[/TD]
[/TR]
[TR]
[TD]OR3289CG-002A[/TD]
[TD="align: right"]28-11-2017 11:10[/TD]
[TD="align: right"]01-12-2017 11:00[/TD]
[TD]Coimbatore[/TD]
[TD="align: right"]04-12-2017 14:29[/TD]
[/TR]
[TR]
[TD]OR7846FG-002A[/TD]
[TD="align: right"]27-11-2017 19:15[/TD]
[TD="align: right"]01-12-2017 10:55[/TD]
[TD]Coimbatore[/TD]
[TD="align: right"]04-12-2017 19:38[/TD]
[/TR]
[TR]
[TD]OR5531NF-003A[/TD]
[TD="align: right"]28-11-2017 19:19[/TD]
[TD="align: right"]01-12-2017 09:53[/TD]
[TD]Coimbatore[/TD]
[TD="align: right"]04-12-2017 20:20[/TD]
[/TR]
[TR]
[TD]OR8259UG-001A[/TD]
[TD="align: right"]28-11-2017 09:16[/TD]
[TD="align: right"]02-12-2017 12:27[/TD]
[TD]Mysore[/TD]
[TD="align: right"]05-12-2017 10:16[/TD]
[/TR]
[TR]
[TD]OR9663UG-001A[/TD]
[TD="align: right"]28-11-2017 11:50[/TD]
[TD="align: right"]01-12-2017 17:18[/TD]
[TD]Mysore[/TD]
[TD="align: right"]05-12-2017 10:41[/TD]
[/TR]
</tbody>[/TABLE]


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?