>
Subject: $$Excel-Macros$$ Re: Worked hour difference calculation
To: "MS Excel & VBA Macros"
Date: Sunday, November 23, 2008, 4:42 PM
Sathish,
Try ownloading the following file:
http://www.scribd.com/doc/5402351/Personnel-Timesheet-081207
Let me know if this helps.
Norman
On
Sathish,
Try ownloading the following file:
http://www.scribd.com/doc/5402351/Personnel-Timesheet-081207
Let me know if this helps.
Norman
On Nov 20, 11:36 pm, "Sathish Jalendran" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Can you please let me know how to find the actual worked hour difference
> b
Excel & VBA Macros
> Subject: $$Excel-Macros$$ Re: Worked hour difference calculation
>
>
> If you want to use the same sheet that you have sent you can use the
> formula
>
> =IF(LEFT(A1,10)=LEFT(B1,10),RIGHT(B1,8)-RIGHT(A1,8),RIGHT(A1,8)-RIGHT
> (B1,8))
>
> When pas
pm
To: MS Excel & VBA Macros
Subject: $$Excel-Macros$$ Re: Worked hour difference calculation
If you want to use the same sheet that you have sent you can use the
formula
=IF(LEFT(A1,10)=LEFT(B1,10),RIGHT(B1,8)-RIGHT(A1,8),RIGHT(A1,8)-RIGHT
(B1,8))
When pasted in cell C1 this will calculate
If you want to use the same sheet that you have sent you can use the
formula
=IF(LEFT(A1,10)=LEFT(B1,10),RIGHT(B1,8)-RIGHT(A1,8),RIGHT(A1,8)-RIGHT
(B1,8))
When pasted in cell C1 this will calculate the number of hours worked.
Set the format of C1 cell to hh:mm:ss and you can see the correct
resu
