Solved

Need Intraday Column

Posted on 2011-03-19
4
284 Views
Last Modified: 2012-05-11
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
Comment
Question by:rtod2
  • 3
4 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
Comment Utility
Try this formula

=if((E2-INT(E2))*24<12,"Morning",if((E2-INT(E2))*24>17,"Evening","Afternoon"))
0
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 500 total points
Comment Utility
For shortened day use

=if(A2="","",mid(text(now()+vlookup(B2,sheet3!A:B,2,false)/24+5/24,"'Weekday 'EEE"),8,10))
0
 

Author Comment

by:rtod2
Comment Utility
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
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
Comment Utility
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query Missing Money orders... 6 53
EXCEL Addin problem 7 23
TT Column Arrange 10 27
cannot get subtotal to work 8 17
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now