IF Function with time date

Closed
Ronnieboo - Oct 5, 2009 at 10:51 AM
 Trowa - Oct 9, 2009 at 09:05 AM
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!

2 replies

Blocked Profile
Oct 6, 2009 at 08:19 AM
Dear Ronnieboo,

Please consider the following suggestion:

https://ccm.net/forum/affich-120460-using-excel-if-function-with-data-validation

Thanks.
0
I quess your problem is how to add a hour to a date.

If you have a date like 2009-07-31 1443 and use a formula to add 1 you notice that 1 day is added.
Which means 1 equals 1 day equals 24 hours.
To add 1 hour you will have to divide 1 by 24 (1/24).

I quess the rest is easy, if not let me know.

Best regards,
Trowa
0