sorry the correct column should be = e3-c3+ ( d3-b3). my aplogy.
On Mon, Feb 22, 2010 at 1:51 PM, OSAVentures Calamba wrote:
> First please removed the date stamp with your time ( "1/1/1900") default
> time stamped on your column e. if you have those in column b, remove them
> as well
>
> Then j
First please removed the date stamp with your time ( "1/1/1900") default
time stamped on your column e. if you have those in column b, remove them
as well
Then just use simple formula of =c3-d3 + (d3-b3). it should give you
correct number of hours.
ernie
On Mon, Feb 22, 2010 at 1:31 PM, Dav
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
De
search for custom editor in google
On Sun, Feb 21, 2010 at 6:56 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi,
>
> Can someboday help me with the commandbars?
>
> I am looking forward to create a custom commandbar with the help of VBA.
> Can you please suggest a source to unde
Dear Rohan,
I have tried that formula. Its fine for normal calculations. But its not
showing correct result when my activity starts on say Monday afternoon 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
Hello -
I'm using an MS Query SQL statement to gather records from an Access
table. The table name varies depending on what I'm doing, so I'd like
to pass the table name and have it select records from that table.
Here is the command I have so far:
SELECT Owners.DisplayName, Owners.Owners
FROM `
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
Hi,
Can someboday help me with the commandbars?
I am looking forward to create a custom commandbar with the help of VBA. Can
you please suggest a source to understand
what all sub properties that we need to specify to make the commandbar. Like
position etc etc.
Thanks
Harpreet Gujral
--
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
