Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Any one an Excel wizard with times and dates?


03 Oct 2013   #1

Home Premium 64 bit
 
 
Any one an Excel wizard with times and dates?

I have items in form dd/mm/yyyy hh:mm:ss. If I want to, say, add 30 seconds and post the
new dd/mm/yyyy hh:mm:ss in the new cell, how do I go about it; please? Adding 00:00:30 to the value contained in the original cell does not work, as naively I thought it might.


My System SpecsSystem Spec
.

03 Oct 2013   #2

win7 home premium-64bit-SP1-IE10
 
 

Hi rundwald

Did you try to use "ASAP" ?
ASAP Utilities for Excel - ASAP Utilities 5.0 Download this free Excel add-in - Recommended by several magazines
Read User guide before use.
I hope that will help.
My System SpecsSystem Spec
03 Oct 2013   #3

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Hi,

Use the TIME and TIMEVALUE functions.

For example, if you have a time 14:45:50 in A1 and want to add 30 seconds to this time and place result in A2..

A2=A1+TIMEVALUE("00:00:30")

hth
Tanya
My System SpecsSystem Spec
.


04 Oct 2013   #4

win7 home premium-64bit-SP1-IE10
 
 

Hello rundwald.
There is a little mistake on Tanya's formula, it should be exactly like this if you have cell b2 selected:
=a2+timevalue("00:00:30")
Good luck.
My System SpecsSystem Spec
04 Oct 2013   #5

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Quote   Quote: Originally Posted by Hanna 1 View Post
Hello rundwald.
There is a little mistake on Tanya's formula, it should be exactly like this if you have cell b2 selected:
=a2+timevalue("00:00:30")
Good luck.
It's all in the interpretation.

My formula was actually correct since I was saying the result would be in A2, and the original TIME is in A1, as I stated.

It is quite common to specify the result to the left of the formula, at least in my experience and interaction with people on other excel forums.

Read it as The result in A2 is equal to... (A2=)..

Hopefully the OP is not completely confused now!
My System SpecsSystem Spec
04 Oct 2013   #6

win7 home premium-64bit-SP1-IE10
 
 

Sorry for that Tanya.
It was nice from you.
My System SpecsSystem Spec
Reply

 Any one an Excel wizard with times and dates?




Thread Tools



Similar help and support threads for2: Any one an Excel wizard with times and dates?
Thread Forum
How do I stop updating dates. Microsoft Office
Saving Excel to server is still 5 minutes of waiting at times Network & Sharing
Formatting Excel 2010, Excel 2003 Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office
Official RTM Release Dates General Discussion
Windows 7 RC1 Possible dates General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:24 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33