How to add 36 hrs with date?

E

Eric

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

macropod

Hi eric,

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

Cheers
 
D

David Biddulph

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
 
D

Dave Peterson

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.
 
D

David Biddulph

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.
 
J

James Silverton

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

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
 
J

James Silverton

David Biddulph said:
Yes, you obviously missed the early part of the thread, James.
Click to expand...

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

Dave Peterson

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

David said:
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.
Click to expand...
 
Top