+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Possibly an "IF" problem as well as formatting

  1. #1
    Registered User
    Join Date
    01-15-2012
    Location
    Carmarthen
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Possibly an "IF" problem as well as formatting

    Ok, I see others in here have similar problems to me. I am trying to streamline the time sheets at work. I am looking at putting a formula in that: when hours worked = more than 35 that figure goes into the box below. I would also like to put dates into columns automatically rather than having week 1 week 2 etc. I'd also like to have negative munbers in the time in lieu box to be marked in a different colour. I know it must be quite simple, but I am new to all this stuff.

    Thanks in anticipation.

    Scattysample Employee timecard1.xlsx

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Possibly an "IF" problem as well as formatting

    Hi,

    See attached.
    You're not clear what you mean by 'the box below' I have assumed you mean cell C16

    When using dates it's advisable to use proper Excel dates and format them as neceesary. Hence rather than just the word 'January' in A7 I have added the date 1/1/2012 and formatted it as "mmmm". Then you can use formulae like those I've put in C7, E7 etc.. I've assumed the dates you want are week ending dates with the week starting on the first Monday of the month

    For your negative number cells use conditional formatting like I have done with C18.

    I'll leave you to use the same ideas on the rest of the sheet's months.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-15-2012
    Location
    Carmarthen
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Possibly an "IF" problem as well as formatting

    Thankyou so very much for your speedy response. I don't have time to look into it this evening (kids running riot and need taming) but will look at it in more detail tomorrow and adjust as you have suggested. thanks again. I am completely new to this format of spreadsheet and I am sure I'll be on again with something else very soon.

    Thanks again.

    Scatty

  4. #4
    Registered User
    Join Date
    01-15-2012
    Location
    Carmarthen
    MS-Off Ver
    Excel 2007
    Posts
    3

    Wink Re: Possibly an "IF" problem as well as formatting

    I cannot find the little star at the bottom left of your post.....but would happily click it if i could see it..... the help you gave me was BRILLIANT and solved the issues i needed help with

    Thanks again for your help.....

    Scatty

    XXX

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Possibly an "IF" problem as well as formatting

    Hi,

    Thanks for the feedback and I'm glad you found it useful.

    Below ever post are four icons on the left in the grey bar, an IP logo, a 6 pointed star, what looks like a couple of books (actually cards) and an exclamation triangle.
    Just click on the star

+ 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