[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

excel worksheet

I have an excel workbook (attached). I've been trying to do a calendar drop down to select date in this format "Monday, August 27, 2012"  but have not been successfull at all.  Also I want to be able to add "time in" + "time out" + luch time (static, 1/2,1,2 hours) = Total hours.

any help would be greatly appreciated.  file is attached. it's all fictious data/names.

I have excel 2010.
Daily-Sheet.xlsx
0
Anthony H.
Asked:
Anthony H.
  • 3
  • 2
1 Solution
 
Elton PascuaCommented:
Is this what you were looking for?

Also, I think the calculation of Total Hours should be Time Out - Time In. If they are having lunch between those times, then it should be inclusive.

Example: In is 8AM, out is 5PM with lunch of 1 hour. Total hours would be 10 instead of 9.
Daily-Sheet.xlsx
0
 
Anthony H.Author Commented:
yeah as far as the time... but how do i do a drop down date picker to show exactly the way it is now?
0
 
Elton PascuaCommented:
Were you referring to the lunch column? Just put a list validation as 0.5, 1, 2.
0
 
Anthony H.Author Commented:
no that's fine the way it is... i just subtract the lunch value.

i want a drop down like this > 
http://www.rondebruin.nl/calendar.htm 

but i can't get it to work. can you help?
0
 
Elton PascuaCommented:
I'm not sure if the control would show on your end, if not, you might want to follow the instructions on how to get it installed.
Daily-Sheet-withCalendar-.xlsm
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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