Re: $$Excel-Macros$$ Re: Time Difference Calculations

2010-02-21 Thread Akash $urkatha
Dear all,   Attached is the sheet containing some Start Date, Start Time on the same Day and End Day, End Time of a particular activity. All viz. Start Date, Start Time, End Day, End Time are mentioned in the separate columns.   Looking at the available data, I would appreciate if I can get

Re: $$Excel-Macros$$ Re: Time Difference Calculations

2010-02-21 Thread ashish koul
TEXT(((TEXT(D3,dd/mmm/)TEXT(E3, hh:mm))-(TEXT(B3,dd/mmm/)TEXT(C3, hh:mm))),HH:MM) On Sun, Feb 21, 2010 at 2:01 PM, Akash $urkatha akash4...@yahoo.com wrote: Dear all, Attached is the sheet containing some Start Date, Start Time on the same Day and End Day, End Time of a particular

Re: $$Excel-Macros$$ Re: Time Difference Calculations

2010-02-21 Thread Akash $urkatha
Hrs in Total based on data available --- On Sun, 2/21/10, roshan goswami.ros...@gmail.com wrote: From: roshan goswami.ros...@gmail.com Subject: Re: $$Excel-Macros$$ Re: Time Difference Calculations To: akash4...@yahoo.com Date: Sunday, February 21, 2010, 8:33 PM hello change the format form