Hello,
I need to add hours to a time date based upon a severity code.
Example cell D2 has the severity code it if is less than 3 the cell will need to show the date/time in cell K2 as an additonal 2 hours 2009-07-31 1443 will need to be 2009-07-31 1643. If D2 is great than 3 it would need to add 6 hours 2009-07-31 1443 would need to be 2009-07-31 2043.
Any assistance is greatly apprecaited!
Configuration: Windows XP Internet Explorer 6.0
Dear Ronnieboo,
|
I quess your problem is how to add a hour to a date.
|
Calculate function every time a cell is changed Dos command to get current date and time Excel 2007 if function date Excel if formula column of data Excel if function define negative dates Excel use formula if there is data For replacement of if function in excel Formatting cells to display time and date in excel Highlight date in colour if before current date How do i calculate insurance for an art work using if function How to create or reset restore data password of nokia mobiles if password forget How to make bold using if function in excel It appears that your computer,clock has been set back please reset the clock to the curent date and time . this prodect wont run Microsoft messenger date or time certificate cannot sign you in Nested if function 2003 Use if function in loop in excel Vba if function together with or function What is the problem of mother board if he beeps in three times