Technology Questions

Go Back   Technology Questions > Software Questions > General Questions > Microsoft Office



Reply
 
LinkBack Thread Tools
  #1  
Old 01-29-2009, 07:50 AM
chisenpb40
Newsgroup Contributor
 
Posts: n/a
Calculating expiration times and dates in Excel 2003

How do I go about calculating expiration times and dates in Excel 2003? For
instance:


Start: 1/1/2009 1600 + 36 hours = EXP: 1/3/2009 0400

I would like to have Excel automatically calculate the expiration time and
date from the start time by referencing a value in another cell. That cell
would contain a drop down list of different values. In short, the user would
enter the start date and time, choose a value from the drop down list, and
Excel would automatically calculate the EXP time and date.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

 
Old 01-29-2009, 07:50 AM
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
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
Excel Date Formatting ex dates like 1795 Mary Ellis Microsoft Office 6 04-13-2009 12:30 AM
Finding the Log in and Log out times and dates on my laptop Helmy Windows XP 1 07-20-2007 06:00 AM
Excel 2003 crashes using save as excel 97-excel 2003 & 5.0/95 .xls gitrinec Microsoft Office 2 04-16-2007 09:31 AM
word 2003 dates William Coleman Microsoft Office 0 01-15-2007 10:19 AM
how can i detect the times and dates my profile has been logged onto? Git-R-Done Windows XP 2 01-04-2007 04:49 AM


New To Technology Questions? Do You Need Help with Your Computer or Device? Do You Need Help with this site?

All times are GMT -8. The time now is 09:48 AM.


2003 - 2010 All Rights Reserved. Technology Questions

Search Engine Friendly URLs by vBSEO 3.3.0