How to add 36 hrs with date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
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 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
 
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.
 
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...
 
Back
Top