Excel time formulas allow you to substract times and dates to obtain days and hours like you would do with regular numbers but.... The format of the
cells receiving the result must be Format/Cells/Number/Number when
working with dates. When you want to
multiply hours and minutes by a rate to obtain a salary you must
use the following formula: See many examples of Excel time formulas including a time management application with no macros. |
Excel Time Formulas
You want to detemine the age of a
person. If in cell "A3" you enter the date of
birth, and in cell "B3" today's date, the
following formula in "C3" would give you a
good approximation of the age (plus or minus a
few days): Dates and times are serial numbers not numbers so I suggest that you always use the "DATE" function when dealing with them. With the DATE function, the arguments are in the following order (year,month,day) whatever the date format specified in your regional parameters. DATE, DAY, MONTH, YEAR
With a date in cell A1
; Hours and Minutes To sum hours over a total of 24, you must modify the format of the result cell. "Format"/"Cell"/"Personalized"/"[h]:mm"
To transform minutes in hours and
minutes (125 becoming 2:05), use this simple
formula (the format of the destination cell
must be hh:mm): |
Support,
Consulting and Training on |
excel-vba.com |
||
The senior super user helping other users on line since 1995 |
||