MyTechSupport.ca :: Your Computer Technical Resource Headquarters! MyTechSupport.ca :: Your Computer Technical Resource Headquarters!
HOME FORUMS RESOURCES & TOOLS ARTICLES ONLINE STORE ABOUT US
Computer Support Forums arrow Software Support arrow Application Problems arrow Topic: Time Math in Excel 2003
November 12, 2019, 11:53:24 PM
 

Home Forum Rules Help Search Mobile Version Login Register

Welcome, Guest. Please login or register.
Did you miss your activation email?
November 12, 2019, 11:53:24 PM

Login with username, password and session length
 Featured Sites:
News
Welcome to MyTechSupport.ca! - Registration is FREE, so why not join our friendly community today?
  0 Members and 1 Guest are viewing this topic.
Pages: [1] Go Down Print
Author Topic: Time Math in Excel 2003  (Read 825 times)
pcamrass
Newbie
*

Karma: +0/-0
Offline Offline

Gender: Male
Posts: 1


Bookmark and Share

View Profile
« on: July 28, 2004, 02:38:44 PM »

PLEASE SUPPLY RELEVANT INFORMATION:
Operating System Version:Windows XP Pro
Problem Application Name & Version:Excel 2003

What formula can I use to add 30 minutes to the time reflected in another cell?

thx.....Paul
Logged

 
ww1961
Jr. Member
**

Karma: +0/-0
Offline Offline

Gender: Male
Posts: 49


Bookmark and Share

View Profile
« Reply #1 on: August 02, 2004, 10:34:17 AM »

try =a1=b1+0:30
Both cells need to be set to time format.
Use the h:mm setting under custom format.
« Last Edit: August 02, 2004, 10:36:49 AM by ww1961 » Logged

 
Pages: [1] Go Up Print 
 
Jump to:  

Powered by MySQL Powered by PHP

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Valid XHTML 1.0! Valid CSS!

Disclaimer
This site is NOT responsible for any damage that the information on this site may cause to your system. Everything you try, whether inspired by the response given from this site or not, is entirely at your own risk. All product names and company names used herein are for identification purpose only and may be trademarks or registered trademarks of their respective owners. We are in no way affiliated or representing any of the companies on this site unless specified.
Back to Top
Stop Spam Harvesters, Join Project Honey Pot Fight Back Against Spammers! Get Firefox! Get Thunderbird! View Sylvain Amyots profile on LinkedIn
Back to Top
Google visited last this page April 04, 2017, 04:45:59 PM