Excel add one hour

excel excel-2003
sanders picture sanders · Sep 21, 2011 · Viewed 142k times · Source

I have in cel A1 with the following contents:

7:30:43 which is a time.

But now i want to use a formula to add one hour. What is the best way or how can i do this?

Answer

leonigmig picture leonigmig · Sep 21, 2011 
=A1+TIME(1,0,0)

Although, maybe this should be posted on Super User.

Related questions

Loop through each row of a range in Excel

This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to remember it. How do I loop through each row …

Read More
Conditional Formatting (IF not empty)

How do I conditionally format a cell so if not blank it is grey? I tried to do 'not equal', but it didn't work. I am using Windows Office 2003 with Windows XP at work. I don't see the same feature …

Read More
How to show current user name in a cell?

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is there any direct way to get this information in a cell? For example as simple as =ENVIRON('User') (which did …

Read More