Saturday, January 3, 2009

Time Math in Excel

You can use the TIME() function to add or subtract hours, minutes or seconds in Excel.  The TIME function takes 3 parameters; HOURS, MINUTES, SECONDS.  To use the TIME function, consider the following examples;

If Cell B14 Contains 12:00AM December 30, the formula =+B14-TIME(13,0,0) would produce 11:00PM December 29

or

If Cell B14 Contains 12:00AM December 30, the formula =+B14+TIME(1,0,0) would produce 1:00AM December 29

Simple?

at No comments:
Subscribe to: Posts (Atom)

Time Math in Excel

You can use the TIME() function to add or subtract hours, minutes or seconds in Excel.  The TIME function takes 3 parameters; HOURS, MINUTES...

  • Delete the Last Line of Data
    I frequently import a specific data-set of text data into Excel.  After I import the data, I need to delete the last line of data. Following...
  • Get the Logged in Users Name
    To get the name of the currently logged in user, you need to first, create a function to call a Windows API function to get the user name.  ...