Thread: time functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
Posts: 91
Default 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