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" wrote in message ...
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" wrote in message
...
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" wrote in message
...
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" wrote in
DB message ...
?? 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" wrote in message
...

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" wrote in
DB message ...
?? 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
...
Yes, you obviously missed the early part of the thread, James.
--
David Biddulph

"James Silverton" wrote in message
...

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" wrote in
DB message ...
?? 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" wrote in message
...
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" wrote in message
...
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