+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Time Formula

Hybrid View

  1. #1
    Registered User
    Join Date
    06-16-2008
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    72
    I couldnt get it work, I changed all the comma's to semi colons (I have excel in Swedish) but still it wouldnt work. Maybe, if you have time, you could look at the attachment and tell me where I am going wrong.

    Thanks for all your help
    Alan

    EDIT
    Forgot to change IF to OM
    That works great.

    Now with the morning journey, its reversed so that I count everthing before 07:30 but nothing after.
    Last edited by AlanWade; 11-18-2008 at 10:44 AM.

  2. #2
    Registered User
    Join Date
    06-16-2008
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    72
    I just cant get the formula in reverse
    This time I would like where a1 is the start time (Before 07:30) and B1 is the end time, as before but only calculated up till 07:30
    eg a1 = 07:00 and b1 = 07:35, it will give an answer of 30 mins But I just cant get it.
    Please can you help again.
    Alan

    EDIT

    GOT IT!

    Thanks darkyam for all your help.

    Regards
    Alan
    Last edited by AlanWade; 11-18-2008 at 11:37 AM.

+ 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