I have a time in a cell formatted in the 12 hour time format (‘1:32:00PM’)
How would I add 7 minutes to it in excel? I tried a normal sum (A1 + 7) but that alters the date?
Thanks.
This formula should work:
=A1+TIME(0,7,0)
Brilliant!
Thanks Mike H! For speed and accuracy.
Your welcome.
Just for refrence, TIME() returns a time portion of a date value. Its parameters are TIME(hours,minutes,seconds).
Just curious, why do you need to add 7 minutes to a date?
I am creating a help sheet for times that things happen on our servers, the servers’ clocks are 7 minutes slow, so the data I am getting is 7 minutes ‘wrong’
So as not to look unprofessional I am obtaining the correct time.
Whoever is administering your servers isn’t nearly obsessive enough! When I was doing that job, I used to reset them to Naval Observatory Time at least once a week!
Days are whole numbers; times are the decimal portion… For day X, X.0 is midnight, X.5 is noon, X.75 is six p.m.
Day 1 is 1/1/1900. 1/1/2003 is day 37622.
To add seven minutes to a timedate, add (7/1440), since there are 1440 minutes in a day.
To add one second to a timedate, add (1/86400). You can put a “time correction” cell on your spreadsheet, in seconds, and reference that value dividing it by 86400 before adjusting your timedate. If you want to be silly, make a dedicated “time correction spreadsheet” somewhere company-public on your server and make all your spreadsheets reference the correction cell 
Or, don’t do that - the CEO will probably be on a plane with his laptop wondering why your spreadsheets complain about not being able to get something off the server.
-AmbushBug
[sub]Whose first real employment involved using Excel 1.00 on a Mac Plus equipped with only two floppy drives. Circa 1986.[/sub]
IIRC, =A1+“00:07:00” should also work. In MS Works you have to code =A1+VALUE(“00:07:00”)
Also, [time] plus 0.004861111 should work.