+ Reply to Thread
Results 1 to 8 of 8

Changing times in excel

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    Perth
    MS-Off Ver
    Excel for Mac 2011. Ver 14
    Posts
    5

    Changing times in excel

    Hi All

    I am a first time member to the forum! I am also very limited in my excel expertise. I have been using excel to create a work schedule with start times and finish times for multiple contracted jobs on any given day over a working fortnight. The problem is that while the duration at each job is unchanged, sometimes due to seasonal changes i need to shift all jobs by anywhere between 30 minutes or 2 hours. Any help would be much appreciated

    Cheers Floydnator

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Changing times in excel

    Hello floydnator,

    Without seeing a sample of your WorkBook setup,

    Add another column for seasonal changes, include that in your formulae, and everything should be O.K.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    07-22-2013
    Location
    Perth
    MS-Off Ver
    Excel for Mac 2011. Ver 14
    Posts
    5

    Re: Changing times in excel

    Thank you! Sorry is there a way i can show you my workbook?

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Changing times in excel

    In you Thread, at the bottom, Select Go Advanced>Select Attachment> and follow the prompts.

  5. #5
    Registered User
    Join Date
    07-22-2013
    Location
    Perth
    MS-Off Ver
    Excel for Mac 2011. Ver 14
    Posts
    5

    Re: Changing times in excel

    Screen Shot 2013-07-22 at 11.22.47 PM.png

    I cannot attach a picture file?

  6. #6
    Registered User
    Join Date
    07-22-2013
    Location
    Perth
    MS-Off Ver
    Excel for Mac 2011. Ver 14
    Posts
    5

    Re: Changing times in excel

    ah yes i can

  7. #7
    Registered User
    Join Date
    07-22-2013
    Location
    Perth
    MS-Off Ver
    Excel for Mac 2011. Ver 14
    Posts
    5

    Re: Changing times in excel

    Hi There

    Was anybody able to help me any further with this one? (above)

    Regards

    Floydnator

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Changing times in excel

    I still don't see a sample of your WorkBook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum X times cell that is changing
    By betorulez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2013, 04:15 PM
  2. Changing one number to another - many times
    By missytordrup in forum Excel General
    Replies: 3
    Last Post: 05-17-2011, 04:21 AM
  3. Excel 2007 : changing the autofilled am/pm for times?
    By cobandrob in forum Excel General
    Replies: 0
    Last Post: 10-04-2010, 03:13 PM
  4. changing 02:00 to 2? times to numbers.
    By johnmitch38 in forum Excel General
    Replies: 1
    Last Post: 09-25-2009, 08:18 AM
  5. Replies: 3
    Last Post: 02-01-2006, 05:55 PM

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