|
|||||||||||||||||
These pages are no longer updated and are only available for archive purposes.Click here to visit the pages with updated information. Calculate with timeThe function =NOW() can be used to return the current date and/or current time,
depending on which number format you use in the cell that contains the function. The
function returns a serial number for the current date. The integer part is the serial
number for the current date (see Dates for more
details). Examples:
If you enter two hours in two different cells, you can perform a calculation with the
two hours. A colon (:) is used as a separator sign between hours, minutes and seconds when you enter hours in a cell. To convert an Excel timevalue to an ordinary decimal value you multiply the timevalue with 24. If cell A1 contains a weekly sum of working hours, you can calculate the amount of money you will get like this (assumes a rate of 250 dollars or pounds or kroner or whatever/hour): =A1*250*24 If you want to add timevalues greater than 24 hours you will have to use the custom number format [hh]:mm on the cells that you want to display timevalues greater than 24 hours.
Document last updated 2000-02-04 12:45:22 Printerfriendly version
|
|||||||||||||||||
|