+ Reply to Thread
Results 1 to 2 of 2

Date&Time calculation driving me insane

  1. #1
    Registered User
    Join Date
    04-06-2005
    Posts
    1

    Date&Time calculation driving me insane

    Hello

    I am attempting to analyse some data to produce performance rates. I have column A with time taken in minutes and seconds (have used [HH] as custom format to display. I have another column B - with number of units (number format).
    I want to divide B by A and multiply by 60 to give me an hourly performance . Currently I am getting some ridiculous numbers.

  2. #2
    Registered User
    Join Date
    04-05-2005
    Posts
    15
    try =(B1/(A1*1440))*60

    Need to convert the time into seconds first and do the rest

+ Reply to Thread

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