$$Excel-Macros$$ Re: Time calculation help

2013-03-17 Thread JosephJoseph
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

$$Excel-Macros$$ Time calculation help

2013-03-17 Thread JosephJoseph
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