time functions
 

Hello, I have Excel 2007

Can anyone help please, I want to display times as 08:00, 09:00, 10:00, etc.

I cannot find a time format to do this, I keep getting 08:00:00 , etc

Also, I want to be able to add 1 hour to a cell value, ie. to calculate cell
A2 = A1+1hour. Can I do this ?

Thanks for all help

K

time functions
 

=a1+1/24
or
=a1+time(1,0,0)

will add an hour.

Can you just format the cell as: hh:mm?

You may want to explain what failed.

KRK wrote:

Hello, I have Excel 2007

Can anyone help please, I want to display times as 08:00, 09:00, 10:00, etc.

I cannot find a time format to do this, I keep getting 08:00:00 , etc

Also, I want to be able to add 1 hour to a cell value, ie. to calculate cell
A2 = A1+1hour. Can I do this ?

Thanks for all help

K

--

Dave Peterson