u can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Avinash Singh
To: MS EXCEL AND VBA MACROS
Sent: Thursday, September 10, 2015 3:09 AM
Subject: $$Excel-Macr
You can simply deduct the times - like (in F2):
=E2-D2
You can then set the format of the result to as "[hh]:mm" - without quotes
and drag / copy as required.
PS: Have a look at your values showing as "0:00" - some of them might need
to be changed to 12 PM so as to give correct results.
HTH
Dear Concern,
Please find the attached excel file and get me solution regarding
difference between timing.
Thanks.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussex