+ Reply to Thread
Results 1 to 3 of 3

Making a time sheet: Having problems with converting numbers to time

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    York
    MS-Off Ver
    Excel 2010
    Posts
    22

    Making a time sheet: Having problems with converting numbers to time

    Morning from York UK, (Excel 2011)

    Ok heres something I cant do in excel.

    A client buys 500 minutes of my time. In one week I spend 340 minutes on the account. I'd like a column to show Time purchased (say 500 Minutes) Time spent and a final section showing time left (but showing negative values in red)

    I hope I've explained this ok but to help here is an illustration of what I'm trying to achieve in Excel 2011.
    http://i216.photobucket.com/albums/c...ps8e0285b7.jpg

    Well Ive hoped Ive explained this OK, any insight welcome :-)

    Thanks,
    David

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Making a time sheet: Having problems with converting numbers to time

    A1 bought, B1 Spent, C1 Remainder=a1-b1?? and conditional formatting
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    01-22-2013
    Location
    York
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Making a time sheet: Having problems with converting numbers to time

    Thanks for reply but still clueless :-( Guess I'll just buy a template!

+ 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. Having problems with formatting time in a time sheet
    By cptrosakelly in forum Excel General
    Replies: 4
    Last Post: 01-07-2014, 06:12 PM
  2. Excel 2007 : Converting Numbers into Time
    By asheysp in forum Excel General
    Replies: 3
    Last Post: 02-25-2011, 08:17 PM
  3. Converting numbers to Time
    By syntax_err in forum Excel General
    Replies: 2
    Last Post: 03-15-2009, 04:12 PM
  4. Converting Numbers to Time
    By aj1125 in forum Excel General
    Replies: 1
    Last Post: 05-28-2007, 05:36 PM
  5. [SOLVED] Converting Numbers to Time
    By Smonczka in forum Excel General
    Replies: 11
    Last Post: 05-31-2005, 01:05 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