Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating
what i need to do is to set a spreadsheet that 1 column is in central
standard time, then the cell below needs it to add 7 hours then the cell below that needs to add 15 hours from the first cell.....how do i do that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating
Assuming starting in A2
=A2+7/24 or =A2+TIME(7,0,0) in A3 =A2+15/24 or =A3+TIME(15,0,0) -- HTH RP (remove nothere from the email address if mailing direct) "john" wrote in message ... what i need to do is to set a spreadsheet that 1 column is in central standard time, then the cell below needs it to add 7 hours then the cell below that needs to add 15 hours from the first cell.....how do i do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating help | Excel Discussion (Misc queries) | |||
Formating | Excel Discussion (Misc queries) | |||
formating | Excel Worksheet Functions | |||
Tab formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |