+ Reply to Thread
Results 1 to 4 of 4

Forumla For Creating wedding timeline/Subtracting time

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    California
    MS-Off Ver
    Office 2008
    Posts
    2

    Question Forumla For Creating wedding timeline/Subtracting time

    Hi there! I have been scouring the web for a formula but haven't been able to create a worksheet that does exactly what we need. I am a wedding photographer and have been trying to create a worksheet for my brides to help them calculate their wedding day timeline. What we are trying to put together is a way for them to enter in a time (like their ceremony start time example 4:00pm) and have the rest of the timeline auto populate the rest of the timeline by deducting minutes from that original time (or adding).

    Example:

    They Enter 4pm for the ceremony. Then the worksheet would automatically subtract 1hr (60 minutes) from 4pm and put 3pm for the time we are shooting bridal party photos earlier in the timeline/worksheet and take 90 minutes from 4pm and insert that into "bride gets dressed" section etc... We haven't been able to find the correct formula to subtract/add time in that manner.

    Any Ideas?

    Thanks so much!
    Last edited by mwphoto; 08-17-2012 at 06:18 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Forumla For Creating wedding timeline/Subtracting time

    see if the attached hives you what you need?
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    California
    MS-Off Ver
    Office 2008
    Posts
    2

    Thumbs up Re: Forumla For Creating wedding timeline/Subtracting time

    My goodness! I think that works great!

    Thank you so much for your help, I reallllly appreciate it (and i am sure our brides will too!)

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Forumla For Creating wedding timeline/Subtracting time

    you are welcome, glad to help let me know if there is anything else i can help with

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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