Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 12th 05, 09:57 PM
tawtrey(remove this )@pacificfoods.com
 
Posts: n/a
Default Adding time to date-time formatted cell

Not sure quite how to do this...

I have a cell (A1) which I have formatted to read the date and time
(MM/DD/YYYY HH:MM AM/PM). That is my starting time. What I want to do now
is be able to input a time period in hours (A2) and have another cell (B1)
add those hours to A1 so B1 will read the "ending time" - formatted with the
(MM/DD/YYYY HH:MM AM/PM) format. Is this possible?

Thanks!

  #2   Report Post  
Old August 12th 05, 10:09 PM
tawtrey(remove this )@pacificfoods.com
 
Posts: n/a
Default

Basically, I want it to lay out like this:

Cell A1: 8/12/05 2:00am
Cell B1: 12 (it takes 12 hours to run this process)
Cell A2: 8/12/05 2:00pm

Thought that might make it more clear what I'm trying to do. Right now, if
I enter "12" in cell B1, it's making my value of A2 read "8/24/05 2:00AM"
  #3   Report Post  
Old August 12th 05, 10:46 PM
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 12 Aug 2005 13:57:01 -0700, tawtrey(remove this
osoft.com wrote:

Not sure quite how to do this...

I have a cell (A1) which I have formatted to read the date and time
(MM/DD/YYYY HH:MM AM/PM). That is my starting time. What I want to do now
is be able to input a time period in hours (A2) and have another cell (B1)
add those hours to A1 so B1 will read the "ending time" - formatted with the
(MM/DD/YYYY HH:MM AM/PM) format. Is this possible?

Thanks!


If the time period in A2 is entered as a number of hours, (e.g. for 2 hrs you
enter the number 2; or for 3 1/2 hours you enter 3.5 or 3 1/2), then:

B1: =A1 + A2/24


--ron
  #4   Report Post  
Old August 12th 05, 10:47 PM
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 12 Aug 2005 14:09:02 -0700, tawtrey(remove this
osoft.com wrote:

Basically, I want it to lay out like this:

Cell A1: 8/12/05 2:00am
Cell B1: 12 (it takes 12 hours to run this process)
Cell A2: 8/12/05 2:00pm

Thought that might make it more clear what I'm trying to do. Right now, if
I enter "12" in cell B1, it's making my value of A2 read "8/24/05 2:00AM"



A2: A1 + B1/24


--ron
  #5   Report Post  
Old August 12th 05, 10:53 PM
tawtrey(remove this )@pacificfoods.com
 
Posts: n/a
Default


thanks!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Cell formats to date fields automatically PCLIVE Excel Worksheet Functions 3 April 12th 05 10:34 PM
Formula with text and reference to a date cell [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 12:07 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017