Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

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).
0
rtod2
Asked:
rtod2
  • 3
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Try this formula

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now