Add a period of time to a referenced "Time" cell?

Colin Legg · #2 02-26-2011, 12:15 PM

Hi Karl,

In Excel, a day (or 24 hours) is 1.
Therefore an hour is 1/24, a minute is 1/24/60, etc..

In your formula:

Code:

=C2+5

You are adding 5 days to C2. Since the format is h:mm AM/PM, it looks like the formula does nothing because the day portion is not displayed.

So if you wanted to add five hours you would use

Code:

=C2+(5/24)

What would be even better would be to have a cell which you put the required hour adjustment into. Say this is cell E1. Your formula then becomes:

Code:

=C2+(E1/24)

Any other formulas which need the hour adjustment could also reference E1. This means that if you ever wanted to change the hour adjustment you could simply change the hours in E1.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Identify "Propose New Time" meeting responses in VBA, and how to response with them	frilian	Outlook	0	09-02-2010 07:48 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM
Excel error: "Too many different cell formats"	enviroko	Excel	0	01-09-2008 07:27 AM
Reminder "snooze time" problem	Steven Wild	Outlook	0	03-08-2006 03:59 PM