Need Intraday Column

I need to calculate three (3) values here >> https://spreadsheets.google.com/ccc?key=0ApGg6c9aeywQdGZ5VzcxZHljZkJjQmJ5Y2hJMFgzYUE&hl=en#gid=0 as indicated, for "Intraday".  Assistance is greatly appreciated.  The "Day" in the preceding column should also be shortened (i.e. Mon for Monday).
rtod2Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try this formula

=if((E2-INT(E2))*24<12,"Morning",if((E2-INT(E2))*24>17,"Evening","Afternoon"))
0
 
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))
0
 
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!
0
 
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.
0
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.