t; Regards - Dave.
>
> Date: Sun, 21 Feb 2010 19:24:25 -0800
> From: akash4...@yahoo.com
> Subject: Re: $$Excel-Macros$$ Re: Time Difference Calculations
> To: goswami.ros...@gmail.com; excel-macros@googlegroups.com
>
> Dear Rohan,
>
> I have tried that formula. Its fine f
12:00
> Hrs and It goes upto Tuesday Afternoon 15:00 Hrs, Total Time shown should be
> (12 Hrs for Monday + 15 Hrs for Tuesday) i.e 27:00 Hrs in Total based on
> data available
>
> --- On *Sun, 2/21/10, roshan * wrote:
>
>
> From: roshan
> Subject: Re: $$Excel-Macros$
(D3-B3+MOD(E3,INT(E3))-C3)*24
>> Also, see attached sheet.
>> Regards - Dave.
>>
>> ------
>> Date: Sun, 21 Feb 2010 19:24:25 -0800
>> From: akash4...@yahoo.com
>>
>> Subject: Re: $$Excel-Macros$$ Re: Time Difference Calculations
>> To: g
at 1:31 PM, Dave Bonallack
wrote:
> Hi,
> Try this formula:
> =(D3-B3+MOD(E3,INT(E3))-C3)*24
> Also, see attached sheet.
> Regards - Dave.
>
> --
> Date: Sun, 21 Feb 2010 19:24:25 -0800
> From: akash4...@yahoo.com
>
> Subject: Re: $$Exce
Hi,
Try this formula:
=(D3-B3+MOD(E3,INT(E3))-C3)*24
Also, see attached sheet.
Regards - Dave.
Date: Sun, 21 Feb 2010 19:24:25 -0800
From: akash4...@yahoo.com
Subject: Re: $$Excel-Macros$$ Re: Time Difference Calculations
To: goswami.ros...@gmail.com; excel-macros@googlegroups.com
Hrs in Total based on data
available
--- On Sun, 2/21/10, roshan wrote:
From: roshan
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 time as how i did in my sheet and substract
On
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 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 activi
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 help
