Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time without using time functions... | Excel Worksheet Functions | |||
Time functions | Excel Discussion (Misc queries) | |||
Time Functions | Excel Worksheet Functions | |||
working with time functions | Excel Discussion (Misc queries) | |||
Time Functions | Excel Worksheet Functions |