G
Guest
Does anyone have any suggestions on how to add 36 hrs on 18-Jun-07 12:00am?
Thank for any suggestions
Eric
Thank for any suggestions
Eric
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
macropod
Hi eric,
Assuming the date & time are in A1, then it's just =A1+1.5, since 36hrs = 1.5 days.
Cheers
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
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.
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.
(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
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
D
David Biddulph
Yes, you obviously missed the early part of the thread, James.
J
James Silverton
David Biddulph said:Yes, you obviously missed the early part of the thread, James.
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.
D
Dave Peterson
This did work in xl2003:
=A1+"36:00:00"
Still different.
=A1+"36:00:00"
Still different.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.