Time Query

[Ashu K]

Dear All,

I have data like below in A and B column. I want output (Consumed Time) in C Column.

CAR-Out	CAR-In	Consumed Time
4/6/2013 10:32	6/6/2013 14:56	52:24:00
4/7/2013 14:40	6/7/2013 17:02	50:22:10
4/6/2013 14:32	7/6/2013 17:02	74:30:00
4/6/2013 14:32	8/6/2013 17:01	98:29:00
4/6/2013 14:32	4/6/2013 17:12	2:40:00
4/6/2013 14:32	8/6/2013 17:02	98:30:00

Please Help.

Thanks

Ashu Kenith

[Ashish Bhalara]

Hi Ashu,

Enter the formula of =B2-A2 (Car-In - Car-Out) and set the Custom Format as [h]:mm:ss

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab - An Excel VBA Macro help Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/b75b70a7-6f27-429a-ae05-d76f955112e9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ashish Kumar]

Hi,

Use this....!!

=TEXT(B2-A2,"[h]:MM:SS")

Regards

Ashish Kumar