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
rundwald

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
Hanna 1

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
TanyaC

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
Hanna 1

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
TanyaC

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
Hanna 1

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
Thread Forum
UP dates fail to DL and Install
Enclosed are two attachments one of the zipped CBS.zip file and on of the update settings page. I have the settings set to check for updates on a daily basis, DL and Install them at 11 AM. The system does check for updates on a daily basis and selects them for action. The updates, although...
Windows Updates & Activation
Saving Excel to server is still 5 minutes of waiting at times
What causes Excel 2007 on Windows7 x64 over 5 minutes to save a file? The file is only 3 megs, and the server has plenty of space. . . I am asssuming a network issue. . .any other thoughts?
Network & Sharing
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Sys Res to previous dates restricted
With XP the period you could step back seemed more generous than with Win7. AFAICS now you can go back no more than about ten days, even when using show more dates. Am I missing something: is there a tweak to extend the step back further, say a month?
Performance & Maintenance
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office


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 21:11.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App