Hi,
A1
0.6875
B1
=1.5/24
=A1+B1
0.6875
=1.5/24
=A2-B2
Please convert the A1 into numbers
--- On Mon, 3/18/13, JosephJoseph wrote:
From: JosephJoseph
Subject: $$Excel-Macros$$ Time calculation help
To: excel-macros@googlegroups.com
Date: M
David & Paul,
Thank you so much for the great help.
All the best..
Joseph
On Sunday, March 17, 2013 4:00:39 PM UTC-4, JosephJoseph wrote:
>
> Hello Everyone
>
> I am trying to add & or subtract hours to or from time..
>
> In cell 1a showing 4:30 PM & Cell 1b shows hours like 1.5 hours or
Keep in mind that to Excel, "time" is the fractional part of a day.
If your convert 6:00 am to "general" format, you'd see it as .25, or
6:00am is 6/24 or .25 days.
so, in order to add hours , you have to convert it to "days".
so, 4:30pm + 1.5 hours is 0.6875 + 1.5/24 = .75
which, when displaye
Use 1A+1B/24
On Monday, 18 March 2013, JosephJoseph wrote:
> Hello Everyone
>
> I am trying to add & or subtract hours to or from time..
>
> In cell 1a showing 4:30 PM & Cell 1b shows hours like 1.5 hours or 2
> hours or 3.5 hours..
>
> I need to add cell 1b 1.5 hours to cell 1a 4:30 PM to get a
Hello Everyone
I am trying to add & or subtract hours to or from time..
In cell 1a showing 4:30 PM & Cell 1b shows hours like 1.5 hours or 2 hours
or 3.5 hours..
I need to add cell 1b 1.5 hours to cell 1a 4:30 PM to get a result of 6:00
pm.
I tried =1a+1b and that did not work.
*Also need t
Prince, David and Viney,
Thanks for trying to help me.
Unfortunately it didn't work...
In teory, it seems to be really simple.
If I do it manualy in Excel plan sheet (Ctrl + U), it works fine...
But when we go to VBA, something is missing.
I will keep trying.
Best regards.
André Luiz D´Avila
A google search gives a lot of options that you can make use of
https://www.google.co.in/search?q=sending+multiple+emails+from+outlook+with+attachment+using+vba
Regards,
Sam
On Sun, Mar 17, 2013 at 12:22 PM, crazybond wrote:
> Dear Experts,
>
> I am looking for excel database/ macros file to