+ Reply to Thread
Results 1 to 2 of 2

Time Formulas

  1. #1
    metaltecks
    Guest

    Time Formulas

    I have a formula in column s that calculates the difference in time from two
    other columns. Then in column T, the answer of column s is converted into
    actual minutes.

    I need to create another formula, but everytime I use the converted minutes
    in column T, it gives me an error. Is there a way I can calculate with these
    numbers as is, or do I have to change them to general numbers, and then run
    my formula?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,712
    Sounds like you might be converting to minutes by using some sort of TEXT formula. If so then you might have a problem using the result if it's text.

    To calculate the difference between two time values in minutes

    =(B1-A1)*1440

    format as number

+ 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