Solved

Need Intraday Column

Posted on 2011-03-19
4
288 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 35174257
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
ID: 35174259
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
ID: 35174270
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
ID: 35174277
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 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