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.

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.