+ Reply to Thread
Results 1 to 2 of 2

Time formulas:make a schedule for printing

  1. #1
    Registered User
    Join Date
    12-05-2005
    Location
    WA
    Posts
    83

    Time formulas:make a schedule for printing

    I went to make a schedule for printing out for manual fill in.
    I changed the format of column A to time.
    I entered the first time in A3

    A3 6:00am
    A4 =A3+:30 didnt work
    A4= A3+30 didn't work
    A4=A3+.5 didn't work
    Those were just guesses.
    What's the right way?

  2. #2
    Dave O
    Guest

    re: Time formulas:make a schedule for printing

    In A4 the formula is
    =A3+(30/1440)
    .... where 1440 = 60 minutes x 24 hours. To Excel, a time such as 6:30
    am is the fraction of a day. Each day is an integer number; a time
    during that day is the integer number plus a fraction.


+ 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