{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

wd DemoLes 8 Rounding and Nesting Functions

# wd DemoLes 8 Rounding and Nesting Functions - 10:38:50...

This preview shows pages 1–3. Sign up to view the full content.

10/30/2010, 10:38:50 e7ea683845c76b46a062ee9680a1e99e3175e82a.xls , Date & Time, Page 1 of 8 ### Working With Time 12:00 AM - 6:00 AM 0.25 12:00 PM 0.50 6:00 PM 0.75 3:13 PM 0.63 Calculating Hours as a Fraction of a Day Hours 0.50 12 Fraction of a day * 24 0.25 6 0.75 18 Computer Lab Timesheet Joan's Classes Calculate # of hours in each class. Day Time In Time Out Hours Class Days Starts Ends Hours Monday 11:00 AM 12:30 PM 1.50 MABS 60 Mon 6:30 PM 9:30 PM 3.00 Tuesday 3:00 PM 4:00 PM 1.00 MABS 101 Tues 6:30 PM 8:30 PM 2.00 Wednesday 1:30 PM 4:15 PM 2.75 ART 05 Wed 6:15 PM 8:30 PM 2.25 Thursday 4:15 PM 11:20 PM 7.08 Total Hrs 7.25 Friday 11:00 AM 12:15 PM 1.25 Find the numbers for these dates: 10/30/2010 40,481.00 11/2/2004 38,293.00 12/31/1899 1.00 Car Rental Record Enter formulas for the yellow cells. Assume each customer departs and returns at the same time of day. Cost per day: \$27.50 Customer Johnson 3/1/2000 3/5/2000 4.00 \$110.00 Wong 3/6/2000 3/14/2000 8.00 \$220.00 Smith 1/1/2000 1/17/2000 16.00 \$440.00 Gonzales 3/10/2000 3/17/2000 7.00 \$192.50 Calculate the number of hours in each fraction of a day: Fraction of a day Dates are stored as numbers in Excel. January 1, 1900 = 1. Date Rented Date Returned Number of Days Total Cost Enter the TODAY function at the top of the sheet. Note: Excel keeps track of time as fractions between 0 and 1. A whole day, or 24 hours, is a "1." Half a day, or 12 hours, is "1/2" or " . 5". One quarter day is 6 hours, or " . 25". Formatting makes the numbers look like "time".

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
10/30/2010, 10:38:50 e7ea683845c76b46a062ee9680a1e99e3175e82a.xls , Date & Time, Page 2 of 8 Years with Company
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern