Need Intraday Column

I need to calculate three (3) values here >> as indicated, for "Intraday".  Assistance is greatly appreciated.  The "Day" in the preceding column should also be shortened (i.e. Mon for Monday).
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try this formula

Saqib Husain, SyedConnect With a Mentor EngineerCommented:
For shortened day use

=if(A2="","",mid(text(now()+vlookup(B2,sheet3!A:B,2,false)/24+5/24,"'Weekday 'EEE"),8,10))
rtod2Author Commented:
Man that is so cool!  You guys are good!

If I could ask a favor before closing this.  Is there any way to have these formulas automatically carry down when adding a new sheet.  I plan on using this daily and that addition will make a big difference.  Will close asap in AM.  Thank you ssa!
Saqib Husain, SyedEngineerCommented:
I am not sure I understand what you are asking. But if I do, you just need to right-click on the sheet tab and click on duplicate.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.