Excel calculation for adding time and calculating remaining time

Hi Guys,

Need some help on formula in Excel. I have attached the file.

Book1 Test.xlsx

Basically I have in cell A1 Open Time, Cell D1 Incident Time based on another Cell. I am trying to have a calculation for column E1,F1,G1,H1 and I1 as below:

E1 - Column B1(open time) plus column D1(1 day 16 hours). Tried B1+D1 but it does not work.
F1 - Show duration of hours remaining from current time minus column E1. Tried Now() minus Duration in E1 but does not work. It shows #VALUE!
G1 - If ticket will expire by today then should show as Y else show as N
H1 - If ticket due to expire by tomorrow only then show as Y else show N
I1 - If ticket will expire more than 2 days time show as Y else N

Hope someone can help me on this?

Thanks Guys.

Regards,
Mark.

Hi,

here it's a VBA forum! See in Excel formulas forum …

___________________________________________
Je suis Charlie

Originally Posted by Marc L

Hi,

here it's a VBA forum! See in Excel formulas forum …

___________________________________________
Je suis Charlie

HI Marc L,

Apologies I clicked on the wrong link.
I will delete this post.

Regards,
Mark.