cpt_109_lesson_17_solution - CALCULATION OF DATE AND TIME...

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

View Full Document Right Arrow Icon
CALCULATION OF DATE AND TIME IN EXCEL When calculating time in Excel, 1 = 1 day The first date on the Excel calendar is 1st January 1900 the following value: 05/07/09 07:50 PM The serial number shows the number of days passed since 1st January 1900,  whilst the decimal fraction shows the time as a fraction of the day. the following value: 05/07/09 This value shows the number of days passed since 1st January 1900. You may vary the format by choosing Style Number format from the menu. 7-May-09 7-May May-09 05/07/09  05/07  You can also find out the actual time by using other display formats.   1 hour = 1/24 =  0.0416666667  1 minute = 1/(24*60) =  0.0006944444  1 second = 1/(24*60*60) =  0.0000115741  07:50:17 PM  07:50 PM  19:50:17  19:50  When the  NOW()  function is entered into a cell with no display format, it gives  When the  TODAY()  function is entered into a cell with no display format, it gives  Examples of different date formats available using the  TODAY()  function In order to do this, Excel uses the decimal fraction in the value given by  NOW() Example of different time formats available using the  NOW()  function
Background image of page 1

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

View Full DocumentRight Arrow Icon
Examples for using these formulas  1/ Calculate the time taken to create a file - Copy to cell A2 - Block the formula in cell A1 using Paste Special / Values - Apply the time display format to A3
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 homework help was uploaded on 04/19/2008 for the course CPT CPT 109 taught by Professor A.sisini during the Fall '08 term at Franklin CH.

Page1 / 8

cpt_109_lesson_17_solution - CALCULATION OF DATE AND TIME...

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