Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07 12:00am?
Thank for any suggestions
Eric

Hi eric,

Assuming the date & time are in A1, then it's just =A1+1.5, since 36hrs = 1.5 days.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Eric" <(E-Mail Removed)> wrote in message news:C1231996-EAF4-4A64-811C-(E-Mail Removed)...
> Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07 12:00am?
> Thank for any suggestions
> Eric

With your date/time in A1, the formula =A1+36/24
Note that you'll need a space betwen the 12:00 and the am
--
David Biddulph

"Eric" <(E-Mail Removed)> wrote in message
news:C1231996-EAF4-4A64-811C-(E-Mail Removed)...
> Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07
> 12:00am?
> Thank for any suggestions
> Eric

Just to be different:

If A1 contains the original date/time:
=a1+time(36,0,0)

And if you want to add 36 hours to a range without using a formula:

Put 1.5 in an empty cell
Edit|copy that cell
select the range to adjust
edit|paste special|check add and values
(reformat the way you like if you have to)

Clear that cell with 1.5 in it.



Eric wrote:
>
> Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07 12:00am?
> Thank for any suggestions
> Eric

--

Dave Peterson

Fascinating! With which version of Excel does that work, Dave? In mine
(Excel 2003), TIME() takes a number of hours from 0 to 23. If you put in 36
hours, it will treat it as 12 hours.
--
David Biddulph

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Just to be different:
>
> If A1 contains the original date/time:
> =a1+time(36,0,0)
....

> Eric wrote:
>>
>> Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07
>> 12:00am?
>> Thank for any suggestions
>> Eric

David wrote on Sat, 15 Sep 2007 14:18:38 +0100:

DB> "Dave Peterson" <(E-Mail Removed)> wrote in
DB> message news:(E-Mail Removed)...
??>> Just to be different:
??>>
??>> If A1 contains the original date/time:
??>> =a1+time(36,0,0)
DB> ...

??>> Eric wrote:
??>>>
??>>> Does anyone have any suggestions on how to add 36 hrs on
??>>> 18-Jun-07 12:00am? Thank for any suggestions Eric

Am I missing something? If the date is in A1, B1=A1+1.5 should
do it. I asume you would format to show date and time.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Yes, you obviously missed the early part of the thread, James.
--
David Biddulph

"James Silverton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Am I missing something? If the date is in A1, B1=A1+1.5 should do it. I
> asume you would format to show date and time.

>> David wrote on Sat, 15 Sep 2007 14:18:38 +0100:
>
> DB> "Dave Peterson" <(E-Mail Removed)> wrote in
> DB> message news:(E-Mail Removed)...
> ??>> Just to be different:
> ??>>
> ??>> If A1 contains the original date/time:
> ??>> =a1+time(36,0,0)
> DB> ...
>
> ??>> Eric wrote:
> ??>>>
> ??>>> Does anyone have any suggestions on how to add 36 hrs on
> ??>>> 18-Jun-07 12:00am? Thank for any suggestions Eric

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:(E-Mail Removed)...
> Yes, you obviously missed the early part of the thread, James.
> --
> David Biddulph
>
> "James Silverton" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>
>> Am I missing something? If the date is in A1, B1=A1+1.5
>> should do it. I asume you would format to show date and time.
>
>>> David wrote on Sat, 15 Sep 2007 14:18:38 +0100:
>>
>> DB> "Dave Peterson" <(E-Mail Removed)> wrote in
>> DB> message news:(E-Mail Removed)...
>> ??>> Just to be different:
>> ??>>
>> ??>> If A1 contains the original date/time:
>> ??>> =a1+time(36,0,0)
>> DB> ...
>>
>> ??>> Eric wrote:
>> ??>>>
>> ??>>> Does anyone have any suggestions on how to add 36 hrs
>> on
>> ??>>> 18-Jun-07 12:00am? Thank for any suggestions Eric

I guess so! I was really reacting to more elaborate things like
TIME() and using Paste Special to replace in situ.



--
James Silverton
Potomac, Maryland

You're right--well, except for the sarcasm part.

David Biddulph wrote:
>
> Fascinating! With which version of Excel does that work, Dave? In mine
> (Excel 2003), TIME() takes a number of hours from 0 to 23. If you put in 36
> hours, it will treat it as 12 hours.
> --
> David Biddulph
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Just to be different:
> >
> > If A1 contains the original date/time:
> > =a1+time(36,0,0)
> ...
>
> > Eric wrote:
> >>
> >> Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07
> >> 12:00am?
> >> Thank for any suggestions
> >> Eric

--

Dave Peterson

This did work in xl2003:
=A1+"36:00:00"
Still different.


Dave Peterson wrote:
>
> You're right--well, except for the sarcasm part.
>
> David Biddulph wrote:
> >
> > Fascinating! With which version of Excel does that work, Dave? In mine
> > (Excel 2003), TIME() takes a number of hours from 0 to 23. If you put in 36
> > hours, it will treat it as 12 hours.
> > --
> > David Biddulph
> >
> > "Dave Peterson" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Just to be different:
> > >
> > > If A1 contains the original date/time:
> > > =a1+time(36,0,0)
> > ...
> >
> > > Eric wrote:
> > >>
> > >> Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07
> > >> 12:00am?
> > >> Thank for any suggestions
> > >> Eric
>
> --
>
> Dave Peterson

--

Dave Peterson