=(ROUNDDOWN(G7,0)+H7-ROUNDDOWN(E7,0)-F7)*24
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Jan/Sun/2012 07:29
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Hours calculate highlighted colum
Just to be clear, in
thanks EVERY BUDDY.
On Sun, Jan 29, 2012 at 10:32 PM, NOORAIN ANSARI
wrote:
> See attached sheet.
>
> On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee
> wrote:
>
>> Respected Masters,
>>
>> Kindly check attached sheet. i need Time calculate in Hours. hopefully
>> its really easier for Masters.
>>
See attached sheet.
On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee wrote:
> Respected Masters,
>
> Kindly check attached sheet. i need Time calculate in Hours. hopefully its
> really easier for Masters.
>
>
> thanks
>
> --
> Yasir Waheed
> Factory Manager
> Sinopak Extrusion Technologies (Pvt.)
Dear Yasir,
Please find the attachment ..
formula : - =(INT(D3)+E3)-(INT(B3)+C3)
On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee wrote:
> Respected Masters,
>
> Kindly check attached sheet. i need Time calculate in Hours. hopefully its
> really easier for Masters.
>
>
> thanks
>
> --
> Yasir Wa
redundant times from the
calculation in this case.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: Saturday, January 28, 2012 5:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Hours calculate highlighted colum
You cannot add time to a date that already has time. The solution has to
take out the date value and time value separately. Otherwise, it will give
inconsistent results.
Here's how the calculation should be. Also, formatting it to [h]:mm:ss will
give an exact idea of the duration.
=ROUNDDOWN(G6,0
Dear Yasir
Please find the solution in the attached file.
On Sat, Jan 28, 2012 at 10:12 AM, yasir_shahjee wrote:
> Respected Masters,
>
> Kindly check attached sheet. i need Time calculate in Hours. hopefully its
> really easier for Masters.
>
>
> thanks
>
> --
> Yasir Waheed
> Factory Manager
