On 2002-04-09 09:00, soto wrote:
Hi There,
I was wondering how to calc this date formula.
3/30/02 9:30 AM + 8.5(Hours)
So I want it to display the answer like
3/30/02 6:00 PM
Any suggestions on how to setup this formula.
Please help!
Thanks
Thanks for responding but that formula did not work for me.On 2002-04-09 09:19, Aladin Akyurek wrote:
On 2002-04-09 09:00, soto wrote:
Hi There,
I was wondering how to calc this date formula.
3/30/02 9:30 AM + 8.5(Hours)
So I want it to display the answer like
3/30/02 6:00 PM
Any suggestions on how to setup this formula.
Please help!
Thanks
In C1 enter:
=A1+B1/24
where A1 houses a value like 3/30/02 9:30 AM and B1 a value like 8.5, which is a decimal time.
On 2002-04-09 09:34, soto wrote:
Thanks for responding but that formula did not work for me.On 2002-04-09 09:19, Aladin Akyurek wrote:
On 2002-04-09 09:00, soto wrote:
Hi There,
I was wondering how to calc this date formula.
3/30/02 9:30 AM + 8.5(Hours)
So I want it to display the answer like
3/30/02 6:00 PM
Any suggestions on how to setup this formula.
Please help!
Thanks
In C1 enter:
=A1+B1/24
where A1 houses a value like 3/30/02 9:30 AM and B1 a value like 8.5, which is a decimal time.
I think i understand the formula but "B1 a value like 8.5, which is a decimal time" in my B1 cell has to display the same as A1. What do you mean by decimal time.
Thanks