Being a simple man i need a simple spreadsheet to add hours to predict a finish time and date. I want to be able to add 36 hours to 15:00 Monday and the spreadsheet tell me the finish is 03:00 Wednesday. I am not bothered about the date so don't want the hassle of having to type them in everytime. Seems simple but I can find anything suitable, any one got any suggestions?

Thanks in anticipation
Martin

Just add them, for instance if you put 04/25/05 15:00 in A1 and 36:00 in B1,
then just add =A1+B1 and it will return 05/27/05 03:00

If you have a date with time and you use an integer for the hours you want
to add

36 then you need

=A1+(B1/24)

you probably need to reformat result


--
Regards,

Peo Sjoblom


"Martin B" wrote in message
...
Being a simple man i need a simple spreadsheet to add hours to predict a
finish time and date. I want to be able to add 36 hours to 15:00 Monday and
the spreadsheet tell me the finish is 03:00 Wednesday. I am not bothered
about the date so don't want the hassle of having to type them in everytime.
Seems simple but I can find anything suitable, any one got any suggestions?

Thanks in anticipation
Martin

What I want is to avoid having to enter the date, I just want to add a
number of hours to the start day and time and find the finish day and time

Martin

Can't be done in that way.

--

Vasant

"Martin B" wrote in message
...

What I want is to avoid having to enter the date, I just want to add a
number of hours to the start day and time and find the finish day and time

Martin

How can Excel know the start date if you don't input it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Martin B" wrote in message
...

What I want is to avoid having to enter the date, I just want to add a
number of hours to the start day and time and find the finish day and time

Martin

On Sun, 24 Apr 2005 19:27:07 +0000 (UTC), "Martin B"
wrote:

What I want is to avoid having to enter the date, I just want to add a
number of hours to the start day and time and find the finish day and time

What rule do you want to use for Excel to compute the starting date?


--ron

"Ron Rosenfeld" wrote in message
...
On Sun, 24 Apr 2005 19:27:07 +0000 (UTC), "Martin B"
wrote:

What I want is to avoid having to enter the date, I just want to add a
number of hours to the start day and time and find the finish day and
time

What rule do you want to use for Excel to compute the starting date?


--ron

he could always use NOW() for the start

On Sun, 24 Apr 2005 20:30:41 -0400, "Joe" wrote:

he could always use NOW() for the start

He could use any number of rules, but he has to define one. Although I would
base it on TODAY() since he's willing to enter the time (I think).


--ron

"Martin B" wrote in message
...
Being a simple man i need a simple spreadsheet to add hours to predict a
finish time and date. I want to be able to add 36 hours to 15:00 Monday and
the spreadsheet tell me the finish is 03:00 Wednesday. I am not bothered
about the date so don't want the hassle of having to type them in everytime.
Seems simple but I can find anything suitable, any one got any suggestions?

Thanks in anticipation
Martin



In Cell A-! Type the start date ( Monday 15:00 ) and format as Custom
dddd h:mm

In Cell C1 =A1+(B1)/24 and format as Custom dddd h:mm

Enter hours for prodject in B1

I got it to work the way you want I think
Joe