wd DemoLes 8 Rounding and Nesting Functions

wd DemoLes 8 Rounding and Nesting Functions - 10/30/2010 ,...

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

View Full Document Right Arrow Icon
10/30/2010, 10:38:50 ### 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".
Background image of page 1

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

View Full DocumentRight Arrow Icon
10/30/2010, 10:38:50 Years with Company
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 8

wd DemoLes 8 Rounding and Nesting Functions - 10/30/2010 ,...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online