Results 1 to 4 of 4

Data and time math

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Data and time math

    Hey,

    Bit confused on how to make this work right.

    I have a date and time list and an electrical consumption list.

    I want to take the date and time, subtract it from the following date and time to get the time passed. Then multiply it by the electrical consumption to get an estimate of usage.
    If I just use the time then when one day goes to the next I get a negative number because I'm not taking into account the date, but I'm not sure how I put the date into my calculations.

    The attached sheet is the raw data, perhaps that will be helpful to see what I'm trying to accomplish.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1